SUMMARY:

• 8+ years of experience in IT as Sr. MS SQL Server Developer working in various domains such as Finance, Insurance and Healthcare in 2012/2008R 2/2008/2005/2000 Windows Environment.
• Extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall, RUP environment
• Strong expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments.
• Experienced in debugging, testing of .NET applications.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Adept in report design, table/query design and automation utilizing VBA modules.
• Extensive experience in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• In-depth experience of Transact-SQL (DDL and DML) operations.
• Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
• Expert in Database Normalization, DE normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cubes using SSAS.
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Experience in designing Database Models using MS Visio and Erwin Data Modeler.
• Experienced in planning and implementing MS SQL Server Security and database Permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Design and build executive ready reports and dashboards from SharePoint in SSRS

TECHNICAL SKILLS:

RDBMS / Databases: MS SQL Server 2012/2008R 2/2008/2005/2000, Oracle 10g,11g, MS-Access 2007/2003

Languages: T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML

Operating Systems: Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools: Microsoft Visio 2007, ERwin Data Modeler 8/7/5

Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services ( SSRS )

Integration Services: SQL Server Integration Services ( SSIS ),Data Transformation Services ( DTS )

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor ( DTA ), Tableau

Internet Tools: Internet Information Server ( IIS 5.0 / 6.0 ), FTP, TCP/IP

SharePoint: Microsoft SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Yardley, PA

Sr. Business Intelligence Developer/ETL Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Involved in identifying the project stakeholder goals and defining project scope.
• Managed customer expectations for project outcomes to ensure full understanding of risks, trade-offs and scope alterations.
• Identified business objectives and the corresponding business requirements.
• Created Business Use Cases and corresponding Atomic Use Cases.
• Led and facilitated DCO sessions with impacted business unit SMEs to capture detailed project requirements.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

Tools: & Technologies: MS SQL Server 2012, T- SQL, Powerpivot, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual Source Safe (VSS), ERwin 8.0/MS Visio 2010

Confidential, NJ

MS SQL BI Developer/ Tableau Developer

Responsibilities:

• Involved Automation of Back Office project and Migration of SQL.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Developed application for business to create Internal Rate of Return (IRR) reports for Private Equity using C#.net plugin for Excel, Excel and Access VBA and SQL Server.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once
• Perform reverse engineering in existing legacy financial applications written in Excel and Access VBA to analyze the impact of huge data source migration project coming forth.
• Create Net Asset reports and charts in Excel using VBA
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Tools: & Technologies: MS SQL Server 2008R2, Tableau, MS Excel 2010/2007/2003, MS Excel 2010/2007/2003, MS Access 2010/2007, Microsoft SQL Server Reporting Services (SSRS) 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2008R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), Erwin 8.0/MS Visio 2010

Confidential

SQL / SSRS / SSIS / SSAS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Implemented user interface in .NET windows form application.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc. ) to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Tools: & Technologies: MS SQL Server 2012, T- SQL, Powerpivot, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual Source Safe (VSS), ERwin 8.0/MS Visio 2010

Confidential, Chicago, IL

SQL Server / BI Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation.
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed the Forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in Visual Basic .NET and SQL Server 2008.

Tools: & Technologies: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Visual Basic .Net, Query Analyzer, SQL Server Profiler, ERwin 7.3/MS Visio 2007.

Confidential

SQL / SSIS / SSRS Developer

Responsibilities:

• Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, Lookup, Multicast, Derived Column, union all, Source, Excel Source, Flat File Source, OLEDB Destination, Flat file destination.
• To achieve business requirements, used For-Each Loop Container, Sequence Container, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Provided Dynamic Configuration, Custom Package Logging, and Error Handling to SSIS template package.
• Created deployment utility to deploy SSIS Packages.
• Created various database objects including Tables, User Defined Functions, Procedures, Packages, Triggers, Indexes and Views based on user requirements.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.
• Use temporary table to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.

Tools: & Technologies: MS SQL Server 2008, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, MS Visio 2007

Confidential

SQL / SSRS / SSIS / SSAS Developer

Responsibilities:

• Actively participated in gathering business requirements and system specification from business users and business analyst.
• Used Microsoft SQL server 2005, SQL server management studio and BIDS and participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Used complex T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Design SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2005.

Tools: & Technologies: MS SQL Server 2008, Windows server 2003, ERwin Data Modeler, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio, Team Server 2008, MS Visio 2007.