SUMMARY

• Over 7+ years’ experience as Business Intelligence Developer using Microsoft BI framework (SQL server, SSIS, SSRS, SSAS) in various business domains including Finance, Insurance, and Information Technology.
• Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Views, Keys, Constraints, Indexes, Triggers, Cursors.
• Strong knowledge and experience in error handling of SSIS packages using transactions, checkpoints (package restart ability features), break points and error logging procedures.
• Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehousing using SQL Server Integration Services (SSIS).
• Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Experience in Writing Complex T - SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Experience in Performance Tuning in SSIS package by using Row Transformations, Block and Unblock Transformations.
• Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity
• Well-versed in usage of SSIS Control Flow items(For Loop, ExecuteSQLtask, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experienced in creating 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 etc...
• Developed cubes in SSAS.
• Experience in creating and managing Error logging, Event Handlers, Package Configurations, creating Jobs, SQL Mail Agent, Alerts, Scheduling SSIS Packages and Custom Logging for SSIS Packages.
• Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized(Cascading parameters), Top N, Summary, ad-hoc reports, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Worked with end users/business analysts to understand business requirements, recommended technical solutions and documented functional requirements.
• Worked on Dynamics CRM for intelligent Customer engagement to build customer trust, loyalty and insight which helps client deliver exceptional customer experiences.
• Used Dynamics CRM to personalize customer experiences and create proactive experiences with the client customers.
• Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, ER diagrams and Data Flow Diagrams, Scripts and formulas, Refresh Strategy and Planning
• Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery.

TECHNICAL SKILLS

Languages: C, C#, SQL, TSQL, JAVA

Databases: MS-SQL Server 2000/2005/2008/2008 R2/2012

IDE Tools: Eclipse, Visual Studio

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting

Services: (SSRS), Crystal Reports, SQL Server Analysis Services (SSAS)

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business

Intelligence Development Studio: (BIDS), Enterprise Manager, SQLProfiler, Query Analyzer, SQL Loader

Operating Systems: Windows 98/2000/2003/ XP/VISTA/7/8.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

SQL Server Developer

Responsibilities:

• Gathering requirements, Design, functional & technical specification, Coding, testing and Document preparation.
• Support Data team and QA team for data extraction and reporting jobs.
• Responsibilities include Database Design and Creation of User Database.
• Logical, Physical Database design.
• Created complex SQL queries for data extraction and reporting.
• Designed and wrote stored procedures, functions using T-SQL.
• Supported application written in Oracle PL/SQL and converted into T-SQL packages.
• Created data extraction ETL jobs using SSIS, extracting data from MS ACCESS, Oracle and MS Excel and loading into SQL Server Databases.
• Creation of backend SQL Server TABLES, INDEXES, VIEWS.
• Deployed SSIS packages to SSISDB using SSIS Catalog Deployment.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Created T-SQL Stored procedures, Functions and Triggers.
• Created reports using SSRS (SQL Server reporting services).
• Created matrix, reports, drill down reports and developed reports with graphs using SSRS.
• Worked on enterprise reporting Lifecycle. Created Ad-hoc reports, monthly, weekly reports.
• Deployed reports in various sources like Web browser in XML and PDF formats.
• Transformed data from various data sources using OLEDB.
• Developed Various Operational, drill-through and drill-down reports using SSRS.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Implementing DTS Packages for transferring data.
• Working in Waterfall SDLC model.
• Created Test cases, Test Plan, and Test conditions for QA testing.
• Supported the QA team for Data validation, Data extraction and SQL Query optimization.
• Developed custom reports using SSRS/SQL Server BI studio.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2008/2012, T-SQL, SSAS, MDX, SSRS, Oracle 10g, PL/SQL, MS ACCESS, Windows 2003/2000(Advanced Server), EXCEL, Crystal reports, Windows 2003 advanced Server, Dynamics CRM.

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Writing advanced T-SQL queries, analyzing existing stored procedures and recommending modifications for efficiency gains.
• UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Created Table Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Testing Packages and fixing bugs using SQL 2012 Business Intelligence Development Studio.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Creating SSIS package to import data from SQL tables to different sheets in Excel.
• Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes.
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Bug fixes in SSIS, SSRS, stored procedures as necessary.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries & stored procedures using SQL Profiler and Index Tuning Wizard.
• Worked in an agile scrum methodology.
• 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 Data warehouse.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull according to the requirement.
• Played roles like production support of SSIS and SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.

Environment: MS SQL Server 2008/2012, MS SQL Server Reporting Services (SSRS) 2008R2/2012, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Analysis Services (SSAS) 2008R2/2012, C#, Microsoft Visual Studio, MS Excel., MS Visio 2013.

MS SQL Server / SSIS / SSRS Developer

Responsibilities:

• Working with business for collecting the proper requirement to implement in development phase and validate it by business approval
• Have a discussion with business for tracking of the requirement on weekly basis to distribute the task by team wise
• Involved in trouble shooting for finding solutions in team
• Data migration from existing old system to new Humana system
• Working on Agile project to attend the daily stand up meeting to update the status on every day.
• Data synchronization across all the environment and Systems with SQL script.
• Involved in report requirement analysis, and Design
• Creating ETL with SSIS to extract data from RDBMS, Excel and CSV, perform business logic and Load data into Excel, Text or RBDMS Destinations.
• Deployment of all the SSIS packages across environment TEST, QA and Production.
• Scheduling of SSIS Package to execute daily, weekly or monthly.
• Bug fixes in SSIS, SSRS, stored procedures as necessary.
• Creating reports in SSRS and providing to business as per requirement.
• Developed complex SSRS reports
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Configure the SSIS Package for run time Parameters and Config file.

Environment: Microsoft SQL Server R2 /2008/2005, Windows 2008, SSIS, SSRS, Qlik View.

Confidential, Columbus, OH

MS SQL Server/ SSIS Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Developed and optimized T-SQL stored procedures and UDF’s to support the bottom line invoice system.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Converted Actuate Reports to the reports in SQL Server Reporting Services and established Reporting Framework.
• Deployed Reports onto the Report Server.
• Used SSIS packages to do file operation, to apply business rules.
• Created several SSIS jobs and packages and executed those tasks
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Created various dynamic reports using SSRS and Crystal reports.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled reports and exported in PDF format.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server Development Studio 2005, 2008, SQL Server Business Intelligence Development Studio 2005, 2008, SQL Server 2000.

Confidential

SQL Server Developer

Responsibilities:

• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Experience in creating Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.
• Created ETL/SSIS packages both design and code to process data to target databases.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Developed SSIS packages and SSRS Reports.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created technical documents for the process of executing the packages
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables.
• Experience in MS SQL Server Configuration, Performance Tuning of stored procedures, SSIS Packages, SSRS Reports.
• Involved in Project tracking using MS Project.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Fixing some of the production issues.

Environment: SQL Server 2000/2005, SSIS, SSRS, SAS MS PowerPoint, MS Project and MS Excel.