SUMMARY

• Around 7 years of professional experience in system analysis, design, development and testing in various domains executed in Client/Server and Data warehouse environments.
• Experienced in all phases of the SDLC for Decision Support Systems including Requirements gathering, Analysis, Design, Development and Testing using MS SQL Server 2012/2008/2005 suite of products (SSIS,SSRS, SSAS)
• Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Hands on experience in designing the database model and maintain referenced relationships for the data integrity.
• Expertise in creating complex Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Experience in monitoring and tuning the SQL server database performance using tools like SQL Profiler, Index tuning wizard and database engine tuning advisor.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages migration Wizard and knowledge on Storage Management.
• Extensive experience in developing Complex SQL queries with multiple complex joins, Group By, Having, Sub queries, Co-related Sub Queries, CTEs, and Views etc.
• Expertise in designing Ad-hoc, Drill-Down, Drill-Through, Matrix, Pivot and Tabular reports to match the needs of the end users by interacting directly with Business Analysts.
• Developed various kinds of graphical reports and scorecards/Dashboards to provide the daily/ weekly and monthly reports to provide a better decision making for the current and future years.
• Knowledge in Creating Cubes and dimensions, defining referenced relationships in SSAS, defining granularity within a measure group and drill through actions, generated KPIs and calculations.
• Hands on experience in Microsoft CRM Reports.
• Creating/Modifying/Locking Logins and Users in Sybase Database.
• An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000/XP/2003 server

Languages: C, C#.Net, VB.Net, XML, HTML, T-SQL, PL/SQL

ETL Tools: DTS, SSIS (SQL Server Integration Services),SSDT

DATABASE: MS SQL Server 2000/05/08/12 , Oracle 9i/10g, MS Access, DB2,SAS

Tools: /Utility: Enterprise Manager, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, SQL Profiler, Erwin, Microsoft Office, MS Visio 2003/2007/2010 , MS Project.

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008, Actuate Report

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Worked extensively on Power Pivot and tabular modeling to meet the business requirements.
• Designed SSIS packages to load from flat files, excel documents and CVS files in SQL 2012.
• Created ETL packages in SSIS using various control flow and data flow functions.
• Scheduled SSIS Packages using SQL Server Agent Jobs.
• Created Charts and Dashboards in Microsoft excel, using tabular model as an input to the excel file. Reports are produced weekly and monthly as well.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Migrated data from SQL Server 2008 to SQL Server 2012 environment.
• Created a huge number of reports and Dashboards in excel and SSRS.
• Assess fraud indicators and report suspicious activity according to company policy
• Design, develop, test and implement ETL processes in support of business requirements.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Maintained the security, integrity and availability of SQL Server.
• Integration, maintenance/conversion, capacity planning issues, and new applications.
• Tuned complex SQL Queries.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).
• Designing data models, contributed to the overall design and implementation of the data Warehouse.
• Participated in all data warehouse planning and execution.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server
• Participated in designing Logical data models for the Data Warehouse.
• Worked on SSAS Tabular model extensively to load the data from SQL Tables.

Environment: SQL Server 2008R2/ 2012, SSIS 2012, SSRS 2012, SSAS 2012, T-SQL, PL-SQL, BIDS, SQL Server Management Studio

Confidential, Dallas, TX

MS SQL Server Developer/SSIS/SSAS Developer

Responsibilities:

• Involved in analysis, design, development, and enhancement of the data warehousing application.
• Installation and configuration of MS SQL Server
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created DTS packages for the data cleansing/transfer and transformation.
• Created DTS Packages using ActiveX Scripts to upload Data from Text files
• Responsible for design and Normalization of the database tables.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Created custom and Ad hoc reports using SSRS.
• Design and implementation of Replication solution for SQL Server 2012 using Enterprise Manager
• Performance tuning SQL statements, queries, triggers and stored procedures
• Modified the current stored procedures to meet current design
• Created indexed views, and appropriate indexes to cut the complex query time.
• Provided day-to-day administration tasks like space and log management.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan

Environment: SQL Server 2005/2008/2012 , T-SQL, SQL queries, VBA Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.

Confidential, NJ

SQL Server Developer (SSIS)

Responsibilities:

• Understanding the requirement of data mart and reporting.
• Compile the reporting requirement and providing the systems analysis to determine the correct data elements.
• Developed SSRS reports based on SQL Server Stored procedures.
• Identifying the need of performing ETL to bring the data into Data Mart.
• Validating the Data Mart using SQL queries and communicating to the ETL developers about the data requirement.
• Developed dashboard using SSRS using Charts, Data Bars, Conditional Formatting, and Advanced Reporting Calculations.
• Implemented advanced usage of Report Parameters to make single report work dynamically to provide the information from multiple dimensions.
• Developed Summary reports, Trend Reports, Aging Bucket Reports to provide Monthly, Quarterly and Yearly Aggregates.
• Designed the reports to convert the reporting requirement into most effective report form.
• Presented reporting sample to the users to get sign off on detail reporting requirement.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XML, DTS, T-SQL

Confidential, Overland Park, KS

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2005 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation of DTS packages to SSIS packages.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: SQL Server 2008R2/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003

Confidential

SQL Server Developer

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Written Various ASP codes for user interactions.
• Written Java Script for different validations
• Used SQL Statements to Present Query responses.

Environment: MS SQL Server 2005,2000, T-SQL, DTS, Microsoft Visual Source Safe 6.0,MS Access 2002,Flat files, SQL Server 2005 Management, and Windows 2003 Server.