SUMMARY

• 5+ years of experience in requirements gathering, design, development, implementation and testing the web applications and ETL tools which includes SSIS, SQL Server 2012, and SQL Server 2008.
• Expertise includes Data Loading, Data Analysis, Data Cleansing and Transformation using SSIS from various sources and targets including SQL, Oracle, MySQL and Flat files.
• 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)/DATA TOOLS.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers.
• Experience in Performance Tuning and Query Optimization.
• Expertise in creating Stored Procedures, Functions, Views and Triggers using SQL Server.
• Experience with dimensional modeling using stars schema and snowflake models.
• Identified and Populated Fact and Dimension tables according to Business Rules.
• Experience with full Software Development Life Cycle (SDLC).
• Experience in Agile Methodology.
• Experience in working with ETL tools (SSIS).
• Experience in Data validations and Unit Testing from source to target.
• Ability to translate business reporting needs and/or operational reporting requests into technical requirements.

TECHNICAL SKILLS

Languages: Transact - SQL, Dynamic SQL, C, C++, Visual Basic 6.0, HTML, DHTML, HTTP, CSS, JavaScript.

RDBMS: SQL Server 2014/2012R2/2008, MS Access.

Database Design Tools and:

Data Modeling: MS Visio, UML, Star Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization, Erwin.

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS)/Data Tools, Visual Studio, PowerCenter.

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, SQL Query Analyzer, Import & Export Wizard, SQL Server 2012 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS)/Data Tools, Web Services.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential

MSBI Developer

Responsibilities:

• Developed and implemented policies for post-production issues management. Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing. Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Visio.
• Involved in meetings with Stakeholders to gather requirements and translated them as technical specs and design docs for the development
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Involved in bulk data migration using SSIS from flat files and xml.
• Created derived columns from the present columns for the given requirements.
• Involved in developing, deploying and monitoring SSIS packages.
• Involved in developing SSIS Package using various control flow and data flow components in BIDS.
• Involved in error handling both in the stored procedures and SSIS packages.
• Involved in fine tuning the ETL packages to improve performance.
• Created pages in the reports to display depend on Prompt values.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Involved in optimizing the performance of reports using optimization techniques.
• Involved in dashboard reports.
• Involved in creating weekly, monthly, quarterly and yearly reports.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Created Solution summary document (SSD) and High Level Design Documents (HLD)
• Responsible to set up a SSD and HLD review call and walk through the solution identified for all the requirements.
• Responsible for getting SSD and HLD approved and submitting the BRC (Business Requirement Configuration) request if needed.
• Helping the developers during the developing phase.

SQL BI Developer

Confidential

Responsibilities:

• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Installed, authored, and managed reports using SQL Server 2014 Reporting Services.
• Managed the migration of SQL Server 2012 databases to SQL Server 2014.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2012 and Flat files.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Tuned various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSISPackages.
• Created SQL server dynamic configurationsforSSISpackages. Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Design tables, Implement relationships (Primary, Foreign Keys) & forward engineer across all the environments using ERWIN 5.1
• Using Visual Basic 6 to retrieve information from SQL Server 2014 by file path. Used C# coding in SSIS packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Data Analyst

Confidential

Responsibilities:

• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Involved in gather user requirements and system specifications.
• Developed stored procedures, functions and database triggers.
• Maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2012 and SQL Server 2008 with latest service packs.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents. Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML). Prepared Functional Specification.
• Extensively involved in regression testing during various phases of the application.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Java, Rational Clear Quest, Rational Clear Case, RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, T-SQL, MS-Excel, Windows server 2003.

Data Analyst

Confidential

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Implemented different types of constraints on tables.
• Designed and implemented stylish report layouts.
• Developed Query for generating drill down reports and SQL server reports in SSRS 2008.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Scheduled the subscription reports with the subscription report wizard.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.