SUMMARY

• Around 8 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2000/2005/ 2008/2012/2014 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012/2014
• Expertise in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) and good knowledge on SQL Server Analysis Services (SSAS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks)
• Successfully extracted Data from Different Databases like Oracle, DB2, and Sybase.
• Expert in Migrating DTS Packages to SSIS 2012/14
• Hands on experience in Erwin
• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modelling
• Extensive reporting experience using SSRS and Crystal Reports
• Well Experienced in Generating parameterized reports in SSRS 2012/2014.
• Excellent working knowledge of Data Mining Models (Classification, Association Rule Mining, Clustering, Genetic Algorithms)
• Extensive experience using Data Mining tools Microsoft Analysis Services.
• Developing reports on SSRS on SQL Server (2000/2005/ 2008/2012/2014 )
• Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in writing expressions in SSRS and Expert in fine - tuning the reports
• Created many Drill through and Drill Down reports using SSRS
• Good Knowledge and experience on SharePoint
• Worked Extensively on ETL process using SSIS package
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in using T-SQL in SQL Server 2000/2005/2008/2012 and 2014 platforms
• Experience in Performance Tuning and Query Optimization
• Well versed in Performance Point Server 2010
• Designed Dashboards, Scorecards and reports using multiple KPI s, OLAP charts and SSRS Reports with PPS
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Expert in creating Parameterized Reports
• QNXT experience including front and backend support
• Involved in testing QNXT Member, Provider, Claims Processing
• Among a team of developers that successfully completed a complex data conversion project that was designed to migrate millions of records to a new system (QNXT)
• Expertise in configuring and customizing JDA SCP and ABPP
• Experience with configuration & development with JDA/i2 solutions
• Experience in Pl/SQL programming
• Strong analytical, problem solving, troubleshooting skills
• Ability to thrive in a fast-changing, dynamic environment
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

SQL Server Tools &Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, MDX, ETL, SSIS, SSAS, SSRS, Micro strategy, Erwin Data modeler, IBM Rational Rose, Crystal Reports 11

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2008R 2/2008/2005/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)Scripting: Shell Scripting

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2010/2012, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0, CSS, HTML, XML, JavaScript, ASP.Net

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software: MS Office 2007/2003/2000, Adobe Professional, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Lead SQL SSRS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2012/2014 and Flat files.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated TSQL script for application.
• Used Visual Team Foundation server for version control, source control and reporting.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T - SQL for SQL Server 2008R2/2012.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Created Reports using Power BI
• Experience on Power Pivot for importing data
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis Connector
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Mining models and deploying and processing SSAS objects.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Experience in developing reports using SSRS.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Developed alternative solutions by adapting current methodologies and procedures
• Prepared detailed technical documentation for ecommerce JDA enterprise operations and plans
• Participated in workshops to discuss technical and functional designs in collaboration with JDA
• Implemented procedures for integration test cases and scenarios for various structures and transactions
• Executed effective processes for creation of contexts to support planning on retained attributes
• Supported technical team members for installation and configuration of JDA enterprise architecture

Environment: SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Power Map, Power Pivot, Power View, Power BI 2013, .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008.

Confidential, Sacramento, CA

Sr. SQL SSRS Developer

Responsibilities:

• Actively involved in design of a new normalized data store (NDS) based on Data Vault Methodology as well as a De - normalized Data Store (DDS) per Dimensional Model.
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Created SSIS packages to SQL Server instances in SSIS 2012 using CDC feature
• Created several SSIS packages for performing ETL operations to transform data from NDS to DDS systems
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012/2014 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008, 2012 and 2014.
• Designed and supported ETL for data pull into reporting and downstream apps as one by merging data sets from existing and new data warehouses.
• Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Created Reports using Power BI
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Performing the tasks of data conversions, adding derived columns in SSIS.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, Power Map, Power Pivot, Power View, Power BI 2013, SharePoint 2010, XML, T SQL, Erwin, Oracle 10g, Talend, MS Excel, ASP.NET, ETL, OLAP.

Confidential, Omaha, NE

SQL SSRS Developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T - SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2012) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server
• Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, Proclarity, T SQL, Erwin, Oracle 10g, MS Excel, ASP.NET, ETL, OLAP, MDX.

Confidential, Sacramento, CA

SQL SSRS Developer

Responsibilities:

• Administering and maintaining large SQL Server 2008, 2005 and 2000 databases with more than 100 million records in individual tables.
• Data Analysis and BI Reports against OLAP/MDX Data cubes using SSRS
• Disaster Recovery planning and implementation - Database mirroring, Log shipping, Active Passive clustering.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• Moving / copying / migrating CUBES (SSAS) from one server to another Server and reprocessing the Cubes.
• Supporting production issues during work and after hours as required.
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV).
• Experience in Microsoft SQL Server CLUSTERING.
• Database Design and maintenance for trading data services and collaboration services for users of financial community (traders, bankers, hedge fund managers).
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages
• Using SQL Server Service Broker to create async. message based database update services.
• Maintaining database security and application security framework using security matrix, windows based group memberships and database roles.
• Extensively using XML for input and export operations.
• Created and Implemented SSIS Packages for importing and exporting data to other data storage like PostgreSQL, FoxPro, and DB2.

Environment: SQL Server 2008, SQL Server 2005, Windows Server 2008, Windows Server 2003, Transact-SQL, SSIS, SSAS, SQL Server Reporting Services, SQL Sentry, VMware.

Confidential

Database Developer/DBA

Responsibilities:

• Installation, configuration the MS SQL Server 2000 and maintenance of servers in various environments.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Develop and maintain in - house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.