SUMMARY:

• Over 8+ years of extensive experience in database design and development using MS SQL Server 2012/ 2008/2005
• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expert in Data Modeling and Multi - Dimensional Modeling
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
• Excellent knowledge on RDBMS principles.
• Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Maintained existing reports and created new reports according to the business needs and integrated them in performance point server.
• Experienced in using global variables, expressions and functions for the reports.
• Maintained securities, roles, subscriptions in report manager in SSRS.
• Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
• Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedure
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Experienced in managing Tableau driven dashboards and reports
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• Experienced in creating complex SSIS and DTS packages for ETL purposes.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, SQL joins and query writing.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
• Highly motivated and competent individual with good communication and analytical skills.
• Creative and passionate for technology.
• Good team player, extremely adaptable and a fast learner.

TECHNICAL SKILLS:

• MS Server 2005/2008/2012
• SSIS
• SSRS
• SSAS
• CDC
• CRYSTAL REPORTS
• MS Access/Word/Excel
• Dimensional Data Modeling
• Star Schema Modeling
• SQL Profiler
• ERWIN
• ODBC
• HTML
• Team foundation Server
• Crystal Reports
• VB.Net
• XML
• UNIX platform
• C
• Share point
• Performance point server
• C#
• Web Service
• FTP
• SFTP
• Sales Force.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

MSBI / SSIS /SSRS / SSAS Developer

Responsibilities:

• Rewriting and optimizing Queries
• Migrating Database from IBM Acis 400 to SQL Server 2012
• Preparing Documentation and specification
• Collaborating with other team members and stakeholders.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.
• Performance tuning, and optimization of procedures and queries.
• Involved in Requirements gathering, Analysis and design of all the client requirements.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spread sheets, Text file, MS Access and CSV files to data base.
• Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.

Environment: MS SQL 2012 R2/2012, SSIS, SSRS XML, T-SQL, MS Access 2010, MS Word, MS Excel, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, San Francisco, CA

MSBI / SSIS /SSRS / SSAS Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Design SSRS and excel reports, expense analysis, and balance sheet analysis.
• Deployed reports onto the production report server through various ways
• Worked on managing Tableau driven dashboards and reports
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Prepared the data mapping for all the migrated jobs using SSIS
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them
• Created script to migrate SQL server object from one environment to other environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2008 packages to SSIS 2012
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, MS Access 2010, MS Word, MS Excel, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Data Automation Using SSIS to automate data processes for input of information
• Rendered and responsible for subscription of reports daily, weekly and monthly using SSRS.
• Involved in migration of reports from Crystal reports to SSRS.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Day to day administration of the Team Foundation Server in support of various development teams
• Used TFS for consolidated, integrated location for all work items (e.g. requirements, change requests, defects or tasks).
• Wrote T-SQL Scripts and performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
• Performed data cleansing techniques using look ups, conditional splits, ranks and partitions.
• Tested SQL Statements using Indexes, stored Procedures and 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 SSAS OLAP CUBES and having partition on cubes on yearly bases for good performance, pulled over those data in Excel pivot functionality sheet as per client requirement.

Environment: MS SQL Server 2008/2012 Enterprise Edition, SSIS, SSRS, T-SQL, SSAS, SQL Profiler,Tableau

Confidential, PORTLAND, MAINE

MS SQL Server / SSIS/ETL Developer

Responsibilities:

• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Data Automation Using SSIS to automate data processes for input of information
• Development of web application components using Microsoft Visual Studio, VB.Net and MVC framework. Involved in migration of reports from Crystal reports to SSRS.
• Performing comprehensive unit testing, system integration and performance testing.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Wrote T-SQL Scripts and performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
• Scheduled Jobs and Alerting using SQL Server Agent.
• Created web service calls to extract data and load in SQL Server
• Performed data cleansing techniques using look ups, conditional splits, ranks and partitions and did data profiling.
• Write clear and concise supporting technical documentation.
• Efficient in writing stored procedures and implemented complex business logic in SSIS.
• Sharing ideas as part of the project team that provides solutions to technical issues.
• Ensure storage, archiving, back-up and recovery procedures are functioning correctly.
• Extracted data from XML files and inserted the data into database.
• Developed complex T-SQL code for the application.
• Performed Look up, Derived Column, and used merge statement for creation of views.

Environment: SSIS, SSAS, SSRS, MS Office, Performance point server, SQL Profiler, report builder, Web Service.

Confidential, SAN FRANSISCO, CA

MS SQL Server /Data Warehouse/SSIS /SSRS developer

Responsibilities:

• Involved in designing Technical specification document, identified various data mappings and the design of Data warehouse.
• Responsible for scheduled jobs and troubleshooting.
• Create new SSIS packages and check performance issue for existing SSIS packages.
• Taking requirements from the business members and putting into technical specifications.
• Create and deliver daily ad-hoc report.
• Closely work with the client to gather business requirements.
• Design, coding, testing, debugging and documentation of applications.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Developed approaches for data warehouse implementation and data acquisition.
• Responsible for the design of Fact tables and Dimension tables
• Analyzed the Requirements of clients and designed business and technical specifications.
• Created dimensions model star schemas using Kimball methodology.
• Responsible for the acquiring of data of different heterogeneous sources like Facets, Flat files, Excel and placing it into the staging area.
• Designed Data Stage ETL Server jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
• Performed data cleansing techniques using look ups, conditional splits, ranks and partitions and did data profiling.
• Wrote Script tasks and used Script component task for complex calculations and codes.

Environment: MS SQL Server 2008 Enterprise Edition, SSRS, SSIS, SSMS, Crystal Reports, T-SQL, report builder