Resume Login

Search for: Jobs   Resumes

Keywords or title City, state or zip code

Sr sql server ssis/ssrs/ssas developer

Post Job For

Free

Posted by:

Name is not set.

Posted date:

11/6/2009

Contact Info:

*****@***********.**.** *****... Show Contact Info

Country:

United States

State:OhioCity:WorthingtonZIP:43085

Email:gstzac@r.postjobfree.com

Similar resumes:java - 2982c# - 932java developer - 1226asp.net - 817sharepoint - 856

Similar jobs:warehouse - 1016sales - 11998project manager - 3530

Jobs vs Resumes

SupportPostJobFree

Becomea

Premium Recruiter

Only $20/month

Map data ©2010 Europa Technologies - Terms of Use

Resume Text:

aSQLSERVER SSIS/SSRS/SSAS/ETL/BI DEVELOPER/DBAWAJIDEmail: gstzac@r.postjobfree.com

Professional Summary:

• 6 + years of administration and development experience on Database Design and Development in SQL server 2005/2000 system in OLTP and OLAP environment.• 6 +years of experience in SSIS, SSAS and SSRS of MS SQL Server.• Excellent command on SQL SERVER 2008.• Data modeling using Erwin Data Modeler and MS Visio.• Expert in designing and implementing relational database model as per business needs.• In-depth knowledge of Transact-SQL (DDL, DML).• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.• 6+ years experience in T-SQL programming.• Reporting Services, Notification Services, Indexing and Full-Text Search• Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility.• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.• Proficient in implementing all transformations available on the SSIS toolbox.• Experience in creating master and child packages, package configurations and logging.• Excellent knowledge of using variables and expressions in packages.• Experience in writing VB scripts in script component task.• Migrated DTS packages to SSIS and modified

using DTS editor wizard. • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).• Experience in writing distributed queries.• Experience in Importing/Exporting Data from various data sources like Excel, Oracle ,DB2 and Flat file using DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.• Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.• Experience in failover clustering.• Experience in implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.• Experience in implementing log shipping and mirroring.• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.• Extensive experience in database tuning, server logins and database permissions.• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes• Experience in designing, creating, processing of cubes using SSAS.• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.• Excellent hands on experience in creating groups

and measures, KPIs.• Expertise in generating reports using MS Reporting Services 2008/2005/2000.• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services..• Experience in XML scripts.• Experience in Dimensional Modeling.• Experience working with XML documents.• Experience in wrting VB scripts for user define functions in SSRS.• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger. • Excellent command on subscriptions, report snapshot and report cache.• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team • Some experience in DB2 queries.• Experience in .NET coding.• Good skills in MSACESS.• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.• Good skills with computer science concepts and programming.• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

Technical Skills:

RDBMS/DBMS: MS-SQL Server 2005/2000/7.0, Oracle 8i/9i/10g, MS Access.Programming Languages: T-SQL, MDX,PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET

Software/Databases: MS SQL Server 2005 / 2000/7.0, MS SQL Server Reporting Services 2008/2005/2000 (SSRS), MS SQL Server Analysis Services 2005(SSAS), MS SQL Server Integration Services 2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP),ProClarity

Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server.

Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS).

Web Servers: IIS 6.0, Apache, Share Point(MOSS), Performance Point Server.

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005,Crystal Reports

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Design Methodology Unified Modeling Language 1.1 using Rational Rose.

Reporting Tools SQL server Reporting Services(SSRS),Crystal Reports,Dundas Chart

ETL Tools SQL Server Integration Services(SSIS),DTS

Academic Qualifications: • Bachelors in Computer ScienceCertification:

• Microsoft Certified Technology Specialist (MCTS)-SQL Server 2005

Professional Experience:

Cardinal Health, Columbus, OH Jun 2008 to Present SQL Server SSIS/SSRS/SSAS Developer

Cardinal Health is a leader in technologies and services that help hospitals manage all medications from the moment they arrive until they are administered to the patient; store and track specialty supplies; and identify and prevent hospital-acquired infections. The scope of the project was a CRM based inventory-management service a application provided by cardinal health which enables customers to track their orders and manage the inventory by reports provided based on business. The project requires Extract and loading data to data warehouse , creating reports and cube.

Responsibilities & Accomplishments:

• Created SSIS packages to clean and load data to data warehouse.• Created package to transfer data between OLTP and OLAP databases.• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.• Created a table to save dirty records. • Extracted data from XML to sql server..• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent • Wrote MDX queries and expressions for use in

Front End BI Applications.• Created KPI Objects in line with Requirement Docs.• Optimized cubes for better query performance.• Extracted data from XML files.• Aggregated cube with 40% performance for better performance.• Processed cube to perform incremental updates.• Wrote MDX expressions to create name sets and calculated members.• Created reports by dragging data from cube and wrote mdx scripts.• Created reports by extracting data from cube.• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.• Created report models and deployed on report server.• Created standard report Subscriptions and Data Driven report Subscriptions• Created report snapshots and cache for better performance.• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.• Created ad-hoc reports, drill down, and drill through reports.• Deployed reports on Microsoft office sharepoint(Moss).• Created user define functions in SSRS using VB script.• Reviewed and adjusted deliverables involved during SDLC involving database changes/development. • Generated test data and tested database to meet the functionalities deliverables in the project

documentation and specifications• Manage Analysis management objects(AMO) using BIDS.• Provided knowledge transfer to the company’s SQL programmers.• Designed maintenance plans • Wrote distributed queries to extract data from different servers.• Created and tuned stored procedures, triggers and tables.• Created several materialized views and UDF’s to be accessed by the new front end applications. • Created views by vertical partitions of tables.• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.• Successfully tested all task in staging and stored all versions of data using team foundation server(TFS).

Environment: SQL Server 2008/2005, BIDS 2005, Reporting servicees 2005, Integration Services 2005,Analysis Services 2005, Windows Server 2003, HealthCare database, Oracle 9i,DB2,Share point server,TFS

WellPoint HMC Richmond Virginia Aug 2007- Jun 2008 SQL Server Developer/SSIS/SSRS/DBA

HMC, a wholly owned subsidiary of WellPoint Inc., an independent licensee of the Blue Cross and Blue Shield Association and the largest health insurer in the United States, works with insurers to keep healthy those who suffer from chronic medical conditions such as asthma, circulatory problems, or diabetes. The data warehouse was on MS SQL Server 2000. Because of the company’s growth and so growth of database that was 3.8 TB,WellPoint increased requirements led them to move to MS SQL Server 2005 having some enhanced features. This project requires monitoring for billing services by creating reports and report model using SSRS

according to business requirement. Migrated from SQL Server 2000 to SQL Server 2005. The data warehouse was populated using SSIS Packages.

Responsibilities & Accomplishments:• Worked with Business Analysts and Users to understand the requirement.• Implement logical design into physical design.• Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.• Created a virtual machine and migrated databases.• Migrated DTS packages using DTS editor wizard in SSIS ,validated and tested all packages on development server• Migrated data from different data sources to sql server.• Tested all stored procedures on testing server• Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application• Created indexes for better performance• Tested the data with complex queries, joins and sub queries.• Successfully migrated the data from SQL Server 2000 to SQL Server 2005.• Created log shipping on servers for disaster recovery.• Created packages to migrate data from different data sources to data warehouse.• Created packages for database maintenance. • Executed Back up database task, check database integrity, rebuild indexes, update statistics task for maintenance• Used VB script in script componenet for data transformations.• Created reports from cubes by writing MDX queries.• Managed Package Configurations in XML Files to efficiently Promote Unit Tested.• Data migration (Import & Export using BCP) from text to SQL Server2005.• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for

the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.• Identified the Measures and Dimensions from the Excel Sheet.• Successfully Extracted transformed and load data into data warehouse.• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server • Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.• Deployed the generated reports directly on the client’s workstation.• Created complex Stored Procedures for better performance to generate reports.• Created dashboards and scorecards using dundas charts.• Deployed reports on share point performance server.• Used VB ,net to create user define functions in SSRS.• Created standard and data driven Subscription, used report manager for securities.• Created report model for Ad-hoc reporting, generate report in XML format.• Used Team Foundation Server (TFS) for version control, source control and reporting.• Documentation for all kinds of reports and DTS and SSIS packages.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, Share point performance server

Franklin Templeton Investments – San Mateo, California Nov 2006 –Aug2007SQL Server Develper(SSIS/SSRS/SSAS)/ETLFranklin Resources Inc. is an investment firm specializing in conservatively managed mutual funds. It offers products under the Franklin, Templeton, Mutual Series and Fiduciary brand names. The sales feed from Central Data Warehouse (CDW) to the CRM had to be modified

to fit the new Salesforce.com architecture, as the existing process was bound to the old schema which was to be discontinued. Project was to alter the process to meet the new business requirements associated with the Salesforce.com

Responsibilities:• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table. • Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id’s, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.• Developed Store Procedure and Staging table for data push from CDW to Sales Force.• Preformed QA Testing for all the Store Procedures to validate the sales results. • Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).• Created Packages by testing and Cleaning the Standardized Data by using tools in Data Flow

Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping. • Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.• Created SQL server configurations for SSIS packages and XML & Windows event logs.• Used sub reports functionality for complex report calculations. • Created parameterized reports passing parameter through report screen.• Used VB .net in SSRS.• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.• Using MDX created calculated members for customized calculated measures.• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.• Documented all database objects, procedures, views, functions & packages for future references.• Performed all QA testing and match results for different environments.• Experience in working with stocks and bonds.• Documented all old and migrated Store Procedures and scripts for future references.

Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Multiplan Inc, New York, NY Jan 2006- Oct 2006SQL Server Developer/ SSIS/SSRS Developer

Multiplan is one of the most progressive and integrated health insurance organizations in the nation providing services to more than two million residents. The project was to migrate data from

various heterogeneous data sources such as oracle, DB2, MS Access, MS Excel and flat files into SQL Server 2005 and maintain Database for the Facility search and Provider search. This was an OLTP database with the data storage of 2.2 TB in size with 210 tables. The presentation Tier was on .Net Framework 2.0 with C# and ASP.Net User Interface.

Responsibilities & accomplishments:• Developed and created logical and physical database architecture using ERWIN.• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.• Successfully implemented indexes on tables for optimum performance.• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.• Created SSIS packages to import data from MS Access, Excel to SQL 2005 • Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel. • Developed scripts to migrate data and the database objects to/from multiple sources.• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.• Developed complex stored procedures using T-

SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.• Migrated data from different data sources.• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.• Used MDX queries for pre calculated measures.• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.• Held responsibility for database maintenance plans.• Actively involved in gathering and analyzing stakeholders requirements.• Created alerts, notifications, and e-mails for system errors.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, HTML

AT&t Dallas TX Nov 2004 – Dec 2005 SQL Server Developer/BI specialist

AT&T Inc is the largest provider of local, long distance telephone services in the United States, and also serves digital subscriber line Internet access. AT&T is the second largest provider of wireless service in the United States, with over 77 million wireless customers, and more than 150 million total customers.. The project focused on

developing a client specific data-mart that enables the company to prospect for new clients and track the activities of existing clients to better serve them and offer them additional products and services.

Responsibilities & Accomplishments:• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.• Created and managed complex batch jobs.• Created complex queries for database auditing purposes. • Performed database Tuning, monitoring, and Scalability Testing• Evolved in the creation and maintenance of index using Index Tuning Advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.• Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions. • Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process. • Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s.• Created a report model on SSAS cubes.• Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source.• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger. • Scheduled packages and different maintenance tasks using MS jobs.• Used Notification services mainly to manage packages on success, completion and failure of deployments and other tasks.

Environment: SQL Server 2000, ERWIN Data Modeler, Windows 2000, Windows 2003 Advanced server, Windows NT, DTS, SSAS, SSRS, SSIS,Crystal Reports

ICICI Bank India Aug 2003-Sep 2004SQL Server DBA

ICICI Bank is India's largest private sector bank by market capitalization and second largest overall in terms of assets. Bank has total assets of about USD 77 billion, a network of over 1,400 branches, and 24 million customers. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. Upgrade from MS SQL Server 7.0 to 2000.

Responsibilities & Accomplishments:

• Involved in requirements gathering, analysis, design, development, change management, • Developed backup restore scripts for SQL Server as needed. • Upgraded to latest version from SQL server 7.0 to 2000. • Written various stored procedures for the purpose of application development.• Tuned SQL statements (Using Indexes) and Stored Procedures.• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.• Disaster recovery and database maintenance plan. • Replication of data using Transactional method. • Migrated data from sql server 7 to sql server 2000 sucessfully• Data conversion from Text File into SQL Server Table. • Created constraints and validated database integrity.• Designed and implemented data access stored procedures and triggers for automating tasks. • Job scheduling and alerts.• Designed and implemented user log in and security.• Extracted Data from MS Access and Oracle.• Created many complex Stored Procedures / Functions and used them in Matrix Reports.

• Creating reports and hosting it in the web for the users.• Created reports for the senior management.• Involved in java coding with java developers• Tested successfully all store procedures on SQL 2000 serverEnvironment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS,Windows 2000 Server,Enterprise Mnager,Query Analyzer,SQL Profiler

Contact this job seeker

©2010  PostJobFree.com - Home - Fresh Resumes - Post Job