SUMMARY

• Over 8 years of IT experience in database design, development and administration using MS SQL Server 2012/2008R 2/2005/2000.
• Strong experience in designing Business Intelligence solutions using MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Excellent experience in working in Financial, Insurance and healthcare domains.
• Experienced in all the stages of SDLC(Software Development Life Cycle) process.
• Extensive experience in creating Tables, Views, Triggers, Stored Procedures, User defined Functions, Indexes and Complex Queries in MS SQL Server using T - SQL.
• Extensive experience in creating Parameterized, Linked, Tabular, Matrix, Drilldown, Drill through, Sub reports, Geographic map as a sub report and Ad hoc reports using SSRS and deploying them onto report servers and SharePoint.
• Expert in creating SSIS Packages using various transformations like Fuzzy Lookup, Fuzzy Grouping, Derived Columns, Conditional Split, Pivot, SCD (Slowly Changing dimensions) based on enterprise data load requirements.
• Expert in designing and deploying ETL solutions using SSIS, DTS, BCP tools to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, Excel, XML, CSV, flat file, Text Format Data.
• Expert in Dimensional Data Modeling and Cube Design in MS SQL Server Analysis Services (SSAS) and deploying them.
• Expertise in creating and implementing Key Performance Indicator (KPI), Calculations, Aggregations, Hierarchies, Partitions, Perspectives in cubes using MDX queries.
• Expertise in Data Warehousing methodologies and concepts, including star schema, snowflake schema, dimensional modeling, Normalization and De-Normalization.
• Proficient in developing Data Flow Diagrams, Process Models, and ER diagrams, Data Models using various Data Modeling tools like Erwin.
• Expert in performance tuning, query optimization, Index management, debugging, statistics sampling and working with SQL profiler, database engine tuning advisor to improve the database process performance.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Recovery procedure and involved in the migration and upgrade of databases.
• Expert in working with various version of Tableau and building the story lines. Strong experience in blending the data for Tableau worksheets and expert in working with different show me tools.
• Expert in working on database scheduled processes using SQL Agent.
• Highly skilled working as an individual as well in a team. Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• Microsoft Reporting services(SSRS)
• Microsoft Integration Services(SSIS)
• Microsoft Analysis Services(SSAS)
• Tableau 8/ 9
• Windows 2 /2000 Advanced Server
• Windows Exchange Server 2003
• Windows9.x
• Windows XP
• Linux
• Unix
• C
• MS-Access
• Oracle 9i
• Windows PowerShell
• IIS 6.0
• C#
• T-SQL
• HTML
• DHTML
• ASP.Net
• VB.Net
• XML
• Java Script and VB Script
• MS Visual Studio 2005
• Crystal Reports
• Microsoft Visio 2003.

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

MS SQL Server / BI Developer

Responsibilities:

• Gathered requirements from business users and documented them based on functional specifications.
• Created and executed several SSIS packages to perform ETL operations of the data from OLTP to data warehouse, as well as from data warehouse to data mart
• Designed and automated various inbound and outbound ETL feeds using SSIS based on enterprise data warehouse data.
• Joined data from different data sources using merge, merge join, and lookup transform.
• Deployed packages in to SSIS catalog and used SQL Server Agent to schedule package execution.
• Set breakpoint to tasks and containers for debugging propose.
• Designed and deployed drill down, drill through, parameterized and sub reports using MS SQL Server Reporting services (SSRS).
• Automated several ETL operations and SSRS reports by replacing the T-SQL code with stored procedures and creating configuration files, environment variables.
• Created scheduled/ad hoc email subscriptions, windows file share (PDF, EXCEL, CSV, XML) subscriptions and data driven subscriptions for SSRS reports based on data representing requirements.
• Rewrote the existing T-SQL queries according to the changing business requirements.
• Adding Key Performance Indicator (KPI) to the cube to evaluate business performance.
• Performed database monitoring and tuning using DB Engine tuning advisor and SQL Profiler and optimized the databases to best performance.
• Created tables, views, indexes, stored procedures, functions using T-SQL based upon the functional specifications and Business Requirement Documentation (BRD).
• Performed unit testing, user acceptance testing of Reports, T-SQL scripts and database objects to test their functionality by creating comprehensive test plans.

Environment: MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS),MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Tableau 9.0, Oracle, MS Excel, MS Access, Toad, Data Modeler, Windows XP/NT.

Confidential, Hopewell, NJ

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Involved in gathering the requirements and defining various campaigns like DM, EM, IB and OB.
• Responsible to identify the leads to load into different campaigns considering various factors like Assets, Age, Tenure and other factors.
• Analyze the client’s behavior pre and post campaign by looking at the logins, conversation, assets.
• Responsible for analyzing the campaigns success by looking at the various measures that impact the client.
• CRM Dashboard
• Gathered business requirements, defined the CRM Dashboard layout for the client analysis and provide a 360 degrees view of a client behavior.
• Analyzed data quality, worked in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to extract the data from various sources like Oracle, CSV, MS SQL Server and text files.
• Used different transformation tools like SCD, Merge, Merge join, derived columns for the SSIS packages.
• Designed, developed and deployed reports in MS SQLServer environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Developed various reports using Maps and Spark line features of MS SQL Server 2008 R2 for analyzing the Client behavior with respect to client’s location and FSA location.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• Campaign Analysis Tool (Tableau)
• Gathered business requirements, defined the tabs for the dashboard and filters for the tool.
• Identified the data sources and wrote stored procedures to load the data into tables for tableau.
• Built the tabs with various charts from show me tool bar like (line chart, pie chart, bar chart).
• Worked with tooltips, colors, sizes and angles for the worksheets to visualize the data.
• Created calculated fields and parameters using various inbuilt functions in Tableau.
• Deployed the dashboard on to the tableau server.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Tableau 8.0, DTS, T-SQL, Oracle, MS Excel, MS Access, Windows NT / XP.

Confidential, NY

MS SQL Server Developer/ BI Developer

Responsibilities:

• Designed and maintained complex ETL processes for enterprise Data Warehouse incremental and full loads using SQL Server Integration Services.
• Worked Involved in planning, defining and designing database using Erwin on Business requirements.
• Created SSIS packages to extract data from OLTP sources like MS SQL Server 2000, Oracle Database, Text Files, Excel and Access to OLAP systems (SQL 2005/2008) and scheduled jobs to call the packages and stored procedures.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split andDerived column.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• 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.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• UsedSQLProfiler template for tracking execution time of T-SQL Statements.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.

Environment: MS SQL Server 2008/2005, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services 2005(SSRS), MS SQL Server Analysis Services(SSAS), MS Windows XP Professional, Oracle 10g, Visual Studio 2005,C#, ASP.Net, VB.Net, XML, MS Visio.

Confidential, Newark, NJ

MS SQL Server Developer/ BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Created Logical and Physical data models using ERWIN data modeling tool.
• Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migrated the DTS packages into SSIS and create new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Performed the ETL operations of the data between Excel/flat files and Database tables/views, during this process resolved many forms of data cleansing issues.
• Extensively used all SSIS transformations such as lookup, merge, derived column, data conversion, audit and aggregate etc.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.
• Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Created various views to be used in various load procedures as pointed to new Database system while maintain the exact business functionality in the process of ERP implementation.
• Modified the Stored Procedures to point to new Data system and resolved the performance issues and created various views to be used in procedures.
• Created several Triggers on production tables to maintain Data Integrity and Cascading operations among tables.

Environment: MS SQL Server 2005/2000, MS SQL Server Integration Services(SSIS),MS SQL Server Reporting Services 2005(SSRS),MS Analysis Services(SSAS), MS Windows server 2003, Oracle 9i, Visual Studio 2005, C#.Net, ASP.Net, Java, XML, ERWIN.

Confidential, Woodbridge, NJ

SQL Server Developer

Responsibilities:

• Responsible for requirement gathering, analysis, design, development, change management, deployment and user training.
• Installation and configuration of MS SQL Server on the server.
• Analyzed requirements and designed the Database using normalized models.
• Responsible for query optimization, analyzing query plans for improve the performance.
• Writing TSQL scripts for creating Tables with constraints, views, stored procedures and triggers, controlling privileges an objects.
• Designed, developed and optimized stored procedures in SQL for Log Entry, Master data and Reports modules.
• Responsible for Database Administrations tasks Backup, Restore, Running scripts on production databases.
• Responsible for Exporting and importing data using Data Transformation Services (DTS).
• Used Query Analyzer to optimize SQL Queries.
• Worked on documenting the application.

Environment: SQL Server 2005/2000, VB.Net, T-SQL, DTS, SQL Profiler, HTML, XML, XSD, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services 2005(SSRS).