SUMMARY

• Over 7 years of IT experience as a MS SQL Server Developer 2000/20 in various Industry verticals like Health Care, Finance, Pharmaceuticals and Retail.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers
• Extensive experience in MS SQL Server 2000/2005/2008 , Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle 8i, DB2, Sybase and MS Access.
• Extensive experience working with DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Designed and developed more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Exposure to Microsoft Visual Studio C#.Net 2005 Win Forms in developing simple data entry applications
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

Operating System: Windows XP, 2k, Server 2012/2008

RDBMS: MS SQL Server 2012/2008 R 2/2008/2005/2005

Database Tools: SSMS,SSIS,SSRS,SSAS,SQL Profiler, Query Analyzer

Programming Languages: T-SQL,C#, VB.Net

Other Tools: Talend, Data Flux, Data Stage, Weka, R, Visual Studio, MS Project, Sharepoint, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

SQL SERVER Developer

Responsibilities:

• Developed stored procedures and triggers in T-SQL.
• Planned, defined and designed data based on the business requirement.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created various Weekly and Monthly reports showing detailed information of the claims filed, Dealers information, Warranty Information.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Writing complex SQL queries using tablejoins (inner and outer), temporary tables, and table variables.
• Created database maintenance planner for the performance ofSQLServer, which covers Database integrity checks and re-indexing.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Involved indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions,data-driven subscription,URL accessetc.

Environment: MS SQL Server 2008/2012, MS Access 2000, MS SQL Analysis Services 2008, MS Excel, Visual Studio 2008, Windows Server 2003, ERWIN

Confidential, Memphis,TN

MS SQL Server Developer/ SSIS Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Designed Database, Tables and Views structure for the new database.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Created complex stored procedures to transfer images, word docs, excel files, pdf files and various other extensions files into the database.
• Performed Unit Testing and SQL Performance Tuning.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Helped end users with the ability to access and utilize the data stored in the data mart.
• Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Worked on using script task, containers to logically execute theSSISpackage to improve performance and execution time.
• Tuned SQL statements (e.g. - Using Indexes) and Stored Procedures.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, Index tuning wizard.

Environment: MS SQL Server 2005, .Net 3.0, SQL BI Suite (SSIS), XML, MS Excel, MS Access 2003 & Windows Server 2003, SQL Profiler, DTS, Data Analyzer.

Confidential, Mount Laurel, NJ

MS SQL Server Developer/ SSRS Developer/SSIS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Responsible for the DimensionalData Modelingand populating the business rules using mappings into the Repository for Meta Data management.
• Extensively used Erwinfor designing the data models.
• Designed the models on both relational and dimensional areas and Generate the DDL using forward engineering
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks
• Created complex SSIS packages using proper control and data flow elements.
• Worked on Designing, developing, implementing, and maintaining reporting frameworks
• Used Lookups Transformation to get the data from reference data sets (SSIS).
• Creating reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services.
• Created sub-reports to present more detailed information about the summary.
• Designed report models based on users requirements, explained and trained users to use report builder to generate their own personalized reports.
• Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008
• Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Created packages using script task, containers to logically execute theSSISpackage to improve performance and execution time.
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
• Developed flowcharts for complex stored procedures.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Designed, developed and modified various interface reports using SSRS.
• Created Tabular reports, Cross Tabs, Drill Down, Charts, Functions and Parameterized report using SSRS.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008 Enterprise Edition, .Net 3.0, SQL BI Suite (SSAS, SSIS, SSRS), XML, MS PowerPoint, MS Excel, MS Access 2003 & Windows Server 2003, Crystal Reports, SQL Profiler, DTS, Data Analyzer.

Confidential, Cranbury, NJ

SSIS/SSRS Developer\DBA

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Aegis Data warehouse (ADW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Wrote Technical Design Specifications, SSIS workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface with ADW.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the SSIS process.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Designed and developed MOLAP and ROLAP cubes with SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Implemented VB.Net script and performed testing.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and Execution Plan and Index Tuning wizard.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, SQL Server Analysis Services (SSAS) 2005, Query Analyzer, Microsoft SharePoint, Microsoft Visio Professional 2005, SAS, Crystal Reports.

Confidential, Cranbury, NJ

SQL SERVER Developer

Responsibilities:

• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Developed stored procedures and triggers in T-SQL.
• Planned, defined and designed data based on the business requirement.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created and maintained databases for Dealers, Vehicle Driver, and Vehicle information.
• Created various Weekly and Monthly reports showing detailed information of the claims filed, Dealers information, Warranty Information.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005/2000, MS Access 2000, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003.

Confidential, Schaumburg, IL

SQL Server Developer/QA

Responsibilities:

• Streamlined QA process to increase efficiency and reduce new product rollout time on daily basis, batch production supervision, BMR certification, audit, and approval of testing.
• Processed, gathered and documented of ongoing testing QA parameters into the technical and business metadata from regulatory inventory.
• Designed first generation Database, Tables and Views structure for the new data mart.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Helped end users with the ability to access and utilize the data stored in the data mart.
• Involved in Implementation and Maintenance of Disaster Recovery solutions such asReplicationand Log Shipping.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and SQL Performance Tuning.
• Responsible for query optimization using MS SQL tools such as Query Analyzer.
• Worked with SQL Profiler and Index tuning wizard.

Environment: MS SQL Server 2000 Enterprise Edition, Access 2000, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler.