PROFESSIONAL SUMMARY

• Extensive experience in Microsoft and other BI Technologies SQL Server, SSAS, SSIS, SSRS, Excel Pivot Tables, Tableau.
• 7 years of work experience in SQL Server Development and experience in OLTP, Operational Data Source ODS , Dimension Modeling, Data warehouse, OLAP and various Database technologies.
• Almost 7 years of IT industry experience in using Microsoft SQL Server 2000/2005/2008/2008R2 for Database Design, Database Backend-Development, Data Migration and Business Intelligence.
• Worked with organizations in diversified domains mainly Banking, Retail, Insurance, Healthcare. Integration and User Acceptance testing experience.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills including the ability to acquaint to fast changing environments.

Database Design/Development

• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
• Good understanding of Database Architecture concepts related to Pages, Database Design and Development in SQL server 2005/2008/2008R2 system in OLTP and OLAP environment.
• Excellent T-SQL programming skills in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Good understanding of Normalization and De-Normalization concept for faster query retrieval
• Experience in data warehouse modeling schemas such as dimensional modeling, star and snowflake schemas.

ETL Development Integration Services

• Experience in Implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages
• Experience in implementing Transactions, Logging, Error files to SSIS Packages.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Experienced in SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Well versed in data Extraction, Transformation and Loading ETL using SQL Server Integration Services SSIS for data migration.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS. slightly related to SSAS/data warehouse data load
• Experience implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages.
• Technical hands-on using SAP Business Objects 4.0 Reports Designer, Web Intelligence, SAP Crystal Enterprize 4.0

Reporting Services/Analysis Services

• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services SSRS .
• Good understanding of Other Reporting Service SSRS aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Good understanding of Data Warehouse Design aspects like Kimball model, Inman model, Star-schema, snow flake schema.
• Good Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
• Experienced in Designing Scorecards, Dashboard reports using Performance Point Server and Publishing them to Microsoft SharePoint Portals.
• Experience using SQL Server Analysis Services SSAS in building OLAP Cubes, defining Referenced Relationships and creating Hierarchies in SSAS
• Experience in data and report analysis based off business requirement and existing reporting tool with good understanding on subtleties of data, processes, business units.

TECHNICAL SKILLS:

Languages PL/SQL, SQL, TSQL ,C, C , 8085/8086 Assembly Language, Unix shell scripting, familiar with groovy Databases Oracle 8i/9i, MySQL, MS SQL Server2005/2008/2012, Teradata Database management tool Oracle Enterprise Management, SQL Server Management Studio, Teradata SQL Assistant Data Modeling Tools MS-Visio, MySQL Workbench Reporting Tools SSRS, Tableau, Web Intelligence, SAP Crystal Enterprize 4.0 Operating System Windows 95/98/NT/2000/XP, UNIX, Linux, MS-DOS ETL OLAP Tools: SSIS 2005/2008/2012 and SSAS 2008/2012 Other Tools MS Visual Studio, MS-Office, SQL plus, familiar with SAP reporting tools. Familiar with OLAP tool SSAS

PROFESSIONAL EXPERIENCE:

Confidential

SQL and BI Developer

Responsibilities:

• Created complex T-SQL queries, stored procedures, and user defined functions UDF's to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Experience in writing Adhoc queires for Business analysts to extract required daily data, Analyzing existing data and performing the data migration.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services SSRS .
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated parameterized/Drilldown, Drill through Cascaded reports using SSRS.
• Documented all database objects, procedures, views, functions packages for future references.
• Created SSIS packages ETL to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
• Experience in dynamic configuration of packages in SSIS.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups in SSIS.
• Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS
• Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the System.

Confidential

Business Information Officer email marketing BI

Responsibilities

• Worked in relational database and reporting technology in design, development and implementation of Microsoft Business Intelligence Data Warehouse systems.
• Involved in designing the new packages also modified the existing packages for the ELT Load using SSIS 2008 to load data to and from various sources..
• Development of logical and physical data model / database, ETL processes, BI reporting / OLAP cubes / OLAP reporting and population and tuning of databases / ETL processes / BI reports / queries while meeting business / user requirements.
• Wrote the T-SQL statements, joins and stored Procedure used in validating the data.
• Developed and executed user acceptance testing, end user knowledge transfer, executed systems implementation and conversion plans.
• Data migration Import Export using BCP from text to SQL Server 2008 R2.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Performed all Conversion goals and objectives which include identifying data for processing email marketing, and validating of historical emails available for migrating to Data warehouse.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table ids, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in EDW.
• Developed Store Procedure and Staging table for data push from local email marketing database to EDW Data Warehouse.

Environment: SQL SERVER 2008, T-SQL, SSRS, SSIS, SSAS, MS Excel, MS Office, Teradata SQL Assistant.

Confidential

BI/Report Developer

• Experience in generating on-demand and scheduled reports for business analysis or management decision
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services SSRS .
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated parameterized/Drilldown, Drill through Cascaded reports using SSRS and Crystal Reports.
• Documented all database objects, procedures, views, functions packages for future references.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Write an Adhoc queires for Business analysts to extract required daily data.
• Weekly receive .txt and Excel files to update the tables in DB.
• Created SSIS packages ETL to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
• Create pivot tables in Excel from SSAS data source.

Environment: SQL SERVER 2005, T-SQL, SSRS, SSIS, SSAS, MS Excel, MS Office

Confidential

DBA/Developer,

Responsibilities

• Actively interacted with Business Users to gather, verify and validate various Business requirements to create reports
• Create Report Subscription
• Data migration Import Export using BCP from text to SQL Server2008.
• Involved in the development of ETL Packages to populate data from the various data sources.
• Worked extensively with front end team to meet the business requirements
• Convert project specifications and statements of problems and procedures to detailed
• Logical flow charts for coding
• Created database objects, relationships and structures
• Worked on writing Stored Procedures using T-SQL as well as analyzing and debugging existing complex stored procedures.
• Provided technical and analytic expertise in responding to complex specialized report requests
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Used Data-Driven Subscriptions to generate automated weekly reports and email it the required users using SSRS 2008.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.

Environment: SQL, T-SQL, SSRS, SSIS, MS Excel, MS Office, VSS

Confidential

Report Analyst

Responsibilities

• Created Process Flow Diagram with details of the different steps involved in the process
• Prepared Detail Design Specifications document that includes process design considerations, dependencies information, restart ability and brief explanation of the entire process
• Participated in business analysis and development of report requirements specifications and business rules
• Data analysis to create reports based on business requirement
• Worked with multiple groups both business and technical across organizations and clients to present the data/process and determine validity
• Worked with data warehouse research team to figure out data, processes and business units requirement
• Provide Post-Implementation Support and transitioned the process to the Production Support/ Maintenance team

Environment: MySQL SQL, SSRS, SSIS, MS Excel, MS Office, Jaspersoft, Goovy-Java, UNIX, Linux

Confidential

Responsibilities:

• Developed user requested reports and pivot tables in Excel.
• Document specifications for business intelligence or information technology IT reports, or other outputs.
• Create or review technical design documentation to ensure the accurate development of reporting solutions.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Check data validation and data completeness.
• Created views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.

Environment: MS SQL Server 2005, MS Excel, MS Office, T-SQL.

Confidential

SQL Developer intern to full time position

Responsibilities:

• Involved in requirements gathering and converting them into database related components
• Involved in installing and configuring of the SQL Server 2000
• Created Tables, Views, Stored Procedures, User defined Functions and other DML, DDL statements
• Extensively used Joins and Sub-Queries to simplify queries involving multiple tables
• Involved in the basic database backup and recovery
• Implemented user login and security
• Involved in the development, design and testing of the system
• Involved in administrative tasks of managing users, logs and profiles
• Documented all the processes involved in maintaining MS SQL database
• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.

Environment: MS SQL Server 2000, MS Excel, MS Office, Windows Server 2003, T-SQL.