SUMMARY

• Over 8.2 years of IT industry experience with Microsoft SQL Server 2008R2/2005/2000, SSIS/SSRS as SQL Developer.
• Professional experience as a T - SQL Developer in Data Model design, writing complex stored procedures, cursors, Functions, triggers, DTS/SSIS,SSRS,SSAS and Power BI in MS SQL Server 2000/2005/2008/2012 in Sybase ASE 12.5/15
• Experience using highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2008.
• Experience in SQL Server DTS and SSIS package design, development, and deployment using SQL 2008/2005 in Control flow, Data flow, Error Handling and Event handling in different heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Good understanding on Internals of SQL Server like Indexing, Statistics Collection, and DMV’s and Information Schemas for analyzing, Metadata.
• Familiar with sizing and systems for specific applications, collecting and analyzing performance data using various tools, establishing baseline performance parameters and implementing tuning and performance improvement measures.
• Data modeling experience with strong Conceptual and Logical Data Modeling skills has experience in requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool ERWIN.
• Good understanding on SQL Server High-Availability features like Windows/SQL Server clustering, Database Mirroring and always on Availability Groups (SQL Server 2012).
• Exposure to .NET framework web and windows application programming languages in C#.
• Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.
• Strong diagnostic, indicative, organizational, interactive, learning and team expertise.

TECHNICAL SKILLS

Special Skills: System Analysis, Design and Architecture, Coding & Testing

DBMS/RDBMS: Server 2000/2005/SQL 2008R2/2012, Sybase ASE 12.5/Sybase 15.03, Oracle, DB2, MS Access, My SQL and PostgreSQL.

Programming Languages: VB 6.0, VBA, VB.Net, SQL, T-SQL, MDX, XML, Perl, Java/VB Script, HTML, Core java

Web Technologies & App Servers: ASP 3.0, IIS 5.0/5.1/6.0

Environment: s: MS Visual Studio.Net 2005/2008, SQL Browser, MSBI, BIDS, SSDT

Operating Systems: Windows 2000/2003/2008 , UNIX

Analysis & Reporting Tools: Power BI, SSAS, SSRS, MS Office 2007/2010, MS Visio, ERWIN, Business Objects, Crystal Reports 8.5/9/10, Data Reports

Configuration Management Tools and Batch Monitoring: SVN, PVCS, TFS, Control-M, CA Unicenter

Utilities: MS Office, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, Nevada

Business Intelligence Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Applied various data transformations
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, and developed to update the database on Daily basis.
• Created reports to retrieve data using Stored Procedures, MDX Queries that accept parameters.
• Provided documentation for all kinds of reports, Power BI, SSAS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Installation & configuration of SQL Server 2012 on Advanced Windows Server 2010.
• Worked with Data Architects to come up with optimal design of Tables Domain & referential integrity.
• Designing, logical, physical, mapping models, for designing and documenting any required ETL processes & all stored procedures, functions or views that are required for project.
• Developed SSIS Packages to Import data from VSAM, XML and CSV (Spreadsheets) to SQL Server.
• Developed ETL process (SSIS) for getting the changed data into staging tables and there by implementing the business logic and data was loaded into Fact tables.
• Excellent knowledge of ETL Process to capture Data from multiple systems & multi-threading in SQL Server Integration Services (SSIS).
• Primary involvement in all phases of Data Conversion and Migration like Extraction, Analysis, Mapping, Cleansing, Transformation, Test Loading, Error reconciliation, and Production Loading.
• Also worked with Error Handling, Execution Plan, Logging, Configuring Packages and Deploying packages into different environments.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Extensively used Team Foundation Server 2008 for version controlling and sharing & uploading at a centralized server box.
• Support and mentor other staff.

Environment: SQL Server 2008, C# Scripting, Java Script, Business Intelligence - MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SSIS Packages.

Confidential, MN

ETL Developer

Responsibilities:

• As a Technical Analyst, Involved in Data Model design for enhancements, writing complex stored procedures, Cursors, Triggers, Views etc. to implement the business logic.
• Involved in integrating different modules, as this is the centralized application and database objects are common across the modules.
• Designed solutions for the multi entity cross border pre trade checks for HF, MF and ETF products
• Interact with business users / other application groups for resolving issues arising out of data mapping/interfaces of their applications
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction
• Involved in Performance tuning andQuery Optimization by using SQL profiler.
• Created SQL Server Integration Service (SSIS)packages between enterprise databases and Third party data source to transfer data.
• Created and updates cubes (measures, dimensions, hierarchies, and relationships), defined calculation (calculated members, named sets and scripts), perspectives using SSAS and MDX.
• Optimized MOLAP Cubes by partitioning them, designing aggregations and implementing attribute relationship for hierarchies.
• Good understanding on Processing and Scalability of cubes on multiple Servers using ETL and XMLA.
• With help of SR Developer worked on AMO objects to dynamically assigned KPI’s and sliding window Partitions for fact tables.
• Optimized data modeling using efficient coding practice, indexing strategies and by statistic analysis on Facts.
• Manage customer expectation by clearly documenting and maintain project deliverables, plans and status throughout the life of project.

Environment: SQL Server 2008 R2/2012,SSIS, SSAS, MDS, EXCEL, Visual Studio Sybase ASE 12.5 and 15.03, ERWIN, Java, Perl, UNIX, SQL Browser, JIRA Green Hooper, Crucible 2.7,Business Objects.

Confidential

Senior SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed and Developed SSISpackages to clean and load data-to-data warehouse.
• Extracted data from JDE (JD Edwards) and loaded into warehouse.
• Setting Package Configurations for executing Child Packages Dynamically through a Parent Package.
• Deploying Packages to SQL Server and executing Packages through jobs.
• Data Analysis and sending questions to onsite/client and understanding the feedback from onsite/client and explaining it to the team for development.
• Designed and developed SSRS Reports as per the Client’s requirement.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading (ETL).
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Used MS- Access/MS-Excel/SSIS Packages for Data Validation/Data Integrity check in “Data Migration Process”.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Log Providers etc.
• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Attributes, Star & Snow Flake Schemas of Data Marts.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence.
• Extensive experience in Online Analytical Processing (OLAP) and Data mining functionality using a combination of client & server-side components in SSAS.
• Experience in Deploying Cubes on the Analytical Server and connecting cube objects with various cubes.
• Interacting with onsite and understanding the requirements.
• Optimized SQL queries as well as cubes to enhance performance.

Environment: MS SQL Server 2008R2/2005, MS Visual Studio 2008/2005, SSIS, SSRS, OLAP, ETL, T-SQL, OLTP, C#, VB.Net, SQL Server Enterprise Manager

Confidential

SSIS, SSAS&SSRS Developer

Responsibilities:

• Used complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintaining Referential Integrity.
• Created Indexes and worked on the performance issues. Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP).
• Worked with Data mining and slowly changing dimensions.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Used MS- Access for Data Validation Process.
• Used DBCC Commands and Update Statistics for SQL Server Maintenance and clearing cache.
• Used MDX Queries to calculate Key Performance Indicator (KPI) for graphical analysis.
• Extracted data from the cube and prepared report using SQL Server SSRS.
• Extensively worked on XML web services and SQL Server reports using the Report Server API. Reports like Ad Hoc Reports; Enterprise and Web reports are being developed and published.
• Designed SQL Database objects in .NET with SQL CLR programming. Created various stored procedures, Functions, Triggers.
• Used most of the ADO.Net concepts like Data Sets, Data Tables, Data Views, Relations, Primary Keys, and Auto Increment Columns and Expressions etc.
• Manage customer expectation by clearly documenting and maintain project deliverables, plans and status throughout the life of project.

Environment: SQL Server 2008R2/2008/2005, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, XML, MS Project, MS Access 2000 & Windows Server 2000.