PROFESSIONAL SUMMARY

• Around 7 years of IT Experience, with strong background in databases and data warehousing concepts.
• Worked on Business Intelligence tools like Microsoft SQL Server 2012/2008, Business Intelligence Development Studio, SSIS (integration services), SSRS (reporting services), and SSAS (analysis services) to help in attaining qualitative strategic informed business decisions.
• Deep understanding of relational databases (RDBMS), triggers, functions, tables, views, data modelling, type of schemas, indexes and normalization.
• Expertise on SQL/T - SQL-DML, DDL, and DCL statements, Stored Procedures, Joins, Sub-queries.
• Hands on experience in creating ETL packages using SQL Server 2012/2008 Integration Services (SSIS).
• Created OLAP cubes using SQL Server 2012/2008 analysis services (SSAS).
• Extensive experience in Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL)
• Conversant with Software Development Life Cycle Development areas
• Proficient in data extraction, data transformation and data loading via Integration Services of SQL Server. Designed data packages using various tasks and transformations in Control Flow and Data Flow tasks respectively.
• Proficient in implementing various transformations under a special type of control flow task called Data Flow Tasks such as Data Conversion, Derived Column and Pivot Tables. Summing up with the various tasks under Control Flow such as Execute SQL tasks.
• Hands on various tasks- Foreach Loop Container, Send Mail Task, and File System Task of the integration services.
• Hands on various transformations- Lookup, Audit, Copy Column, Derived Column, Conditional Split, Merge Join, Multi Cast, OLE DB Command, Union All of the integration services.
• Utilized Variables and Package Configuration of the integration services.
• Experience in transforming the raw data from various data sources using various tasks and transformations of SSIS for cleaning bad data and validating data.
• Hands on star schemas, snowflake schemas, extended star schema and hybrid schemas, dimensional modeling and reporting tools, Data store concepts, Data Marts and OLAP technologies for Ad hoc reporting.
• Knowledge of source control management systems like Team Foundation Server (TFS).
• Worked on the reporting services of SQL Server developing tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.
• Hands on deploying reports; Creating report schedules and subscriptions; Managing and securing reports.
• A go-getter and work best under pressure
• Excellent ability to communicate effectively to both technical and non-technical audiences in written and non-written formats
• Strong people skills, charismatic & possess excellent interpersonal skills with ability to work cross-departmentally
• Self-motivated, highly analytical, organized, and detail-oriented with the ability to meet project timelines in a fast-paced environment
• Good documentation and troubleshooting skills with customer service-oriented attitude and top-notch time management
• Ability to adapt to new technologies by self-learning with strong conceptual knowledge of data warehousing.

TECHNICAL SKILLS & TOOLS

Languages: SQL, T-SQL

RDBMS/Databases: MS SQL Server 2012/2008 R2/2008, MS Access

ETL Tools: SQL Server Integration Services(SSIS)

Reporting Tools: SQL Server Reporting Services(SSRS)

Analysis Tools: SQL Server Analysis Services(SSAS), MS Excel

Operating Systems: Windows 7/ XP

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Version Control Tools: Knowledge of Team Foundation Server(TFS)

MS Office: Visio, Excel, Pivot, Advanced Excel, Access, Word, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. SQL SSIS/SSRS Developer

Responsibilities:

• Work with Business Analysts and Users to understand the requirement.
• Work on different levels of ETL Loads to extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Deploy the SSIS packages in file system and MSDB databases.
• Create tabular, matrix, parametric and dashboards and scorecards reports according to business requirement.
• Schedule reports, reports services documents and dashboards using Schedule Manager.
• Create packages to migrate data from different data sources to data warehouse.
• Create packages for database maintenance.
• Experience in applying various transforms, SCD (slowly changing dimensions) to maintain the history of the data, aggregate, multicasting, conditional split, Merge, Merge join, Pivot etc.
• Use SSIS control flow tasks Loop Containers, FTP, Bulk insert, Transfer job task etc. and different data flow tasks such as Derived Column, Fuzzy lookup, data conversion etc.
• Write scripts for Data Profiling, reported the risks, issues after running those scripts on the source systems and used those results in designing the ETL.
• As SSIS developer, work on Designing and Implementing the ETL processes.
• Create Packages using SSIS to load data from source to DWH.
• Apply Derived Column, Multicast, and Conditional Split transformations while loading Data into DWH
• Design packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
• Extract data from sources and transform the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• Good knowledge in creating Event Handlers for Error Handling.
• Create Configurations to change the package properties dynamically
• As SQL developer, work in the application development side like enhancements and letter (XML) changes as per the customer requirements.
• As a SQL database Developer, work on Designing Tables, Stored Procedures, Functions, Triggers, complex scripts using T SQL
• Experience working on 24X7 environment
• Work with the overall systems analysis, design, development and implementation
• Develop complex SQL Server database to responsively handle data retrieval (T-SQL, Triggers, Stored Procedures) and SSIS Packages
• Work in development of entire web applications and generate reports in the desired format of HTML and PDF using SQL Reporting Services.
• Extensive interaction with clients and business teams to provide technical support and measure the scalability, consistency and accuracy of the applications.

Environment: MS SQL Server 2012, SSIS 2012, SSRS 2012, T-SQL, Visual Studio 2012, Microsoft Visio, Windows 2007,SQL Server Business Intelligence Development Studio (BIDS) MS Access 2007

Confidential . Dallas, Texas

Sr. SQL BI Developer

Responsibilities:

• Perform gathering and analysis of the rules and requirements of project.
• Develop project scope, schedule planning and project impact assessments.
• Design and test packages to extract, transform and load data (ETL) using SSIS.
• Develop SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Extensively use of SSIS variables for storing the values, which are used in various components of Data Flow Task.
• Work on execution of the paths depending on the success or failure of other tasks with precedence constraints to determine the workflow.
• Use a variety of Data Flow Transformations, like Derived Column, Copy Column, Lookup, Data Conversion, Union All, Multicast and while developing the packages.
• Design packages which are utilized for tasks and transformations such as Execute SQL Task, Data Flow Task, Data Conversion, Foreach Loop Container, Lookup, Aggregate, OLE DB Command.
• Design and implement comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
• Schedule package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
• Develop error handling routines for packages using both script tasks in the error handling tab.
• Create and configure OLAP cubes using SSAS, assist in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Write Documents test cases corresponding to business rules and other operating conditions and generated the Weekly Test reports about Test status and Defects summary.
• Create and develop customized reports to satisfy business needs using SSRS.
• Develop Reports with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.).
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports.
• Perform the appropriate documentation for all the projects for future reference.
• Create and maintain documents to capture the different changes in SSIS packages.
• Perform query optimization for faster processing of queries, developed stored procedures, user defined functions, triggers, indexes and views.
• Create user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to the Clients.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2008 R2/2012, MS SQL Server Analysis Services 2008/2008 R2/2012, MS SQL Server Reporting Services 2008/2008 R2/2012, T-SQL, Windows 7, PowerBuilder, ASP.Net, SharePoint, Dashboard.

Confidential, Duluth, Georgia

SQL Server Developer/SSRS/SSAS

Responsibilities:

• Work on complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation
• Perform installation and configuration of SQL Server 2008 with latest Service Packs.
• Develop stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Create and execute SQL Server Integration Service (SSIS) packages to populate data from the various data sources, create packages for different data loading operations for many applications.
• Develop and maintain enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modify existing reports as needed.
• Develop Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, rows Updated and rows Unchanged in appropriate SQL Tables.
• Use Checkpoints in packages to enable the package to run from the point of failure.
• Create package dependencies by calling Child packages within Parent.
• Use Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Use the Default logging as well as Custom Log to keep track of the package.
• Design, administrate and develop Star Schema Data marts
• Design and create OLAP cubes, MDX, defining the dimensions and relationship between dimensions and measure groups
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Create stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Used SQL Server Profiler to trace the slow running queries and attempt to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, MS SQL Server Integration Services2008 (SSIS), MS SQL Server Reporting Services 2008(SSRS), MS SQL Server Analysis Services 2008(SSAS)

Confidential, Cambridge, MA

SQL Developer/Analyst/SSIS/SSRS

Responsibilities:

• Act as the key point of contact for data requests to drive analytics driving business intelligence insight
• Define/develop/implement robust, automated solutions for extracting, transforming, and loading disparate data sources
• Build and maintain business intelligence reports and dashboards using a variety of tools with emphasis on SQL Server, SharePoint and Excel
• Design reports using Microsoft BI Suite, specifically SSIS & SSRS, via Report Builder, and Visual Studio
• Apply data warehousing best practices in the design of robust/sustainable reporting solutions
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
• Monitor systems capacity and performance and tune, when necessary
• Plan and execute backup and disaster recovery procedures
• Develop and document processes and procedures while identifying and implementing improvements
• Recognize and deal appropriately with confidential and sensitive information
• Perform DBA functions
• Administer SharePoint Online environment and assist in migration from on premise SharePoint 2010 environment
• Follows up on all matters requiring attention, coordinating with resources from across the company to deliver desired outcomes
• Problem-solves and resolves internal and external customer and vendor-related issues, escalating appropriately when necessary
• Maintains connectivity to e-mail and voice mail on-going to monitor issues that require immediate attention

Confidential

Business Analyst

Responsibilities:

• Collect requirements from key stakeholders, customers, and subject matter experts to define the scope and requirements
• Write functional and non-functional specifications for the application
• Perform Gap analysis and conduct internal walkthroughs with the project team and insure comprehension.
• Responsible to work with various business and technical resources to review, analyze and evaluate data fields and application interfaces in order to create required business requirement documents.
• Involve in JAD sessions to gather and analyze requirements.
• Responsible for following appropriate standards and requirement gathering processes.
• Create and review of Business Requirement documents.
• Perform project management leadership functions as required.
• Model business requirements and logically convert them to functional requirements by using UML.
• Assist in performing GAP analysis (As-Is & To-Be) and support full traceability for all the software artifacts.
• Design and develop Use Cases, Activity Diagrams and Sequence Diagrams using Rational Rose
• Analyze, test and validate data.
• Ability to work with senior executives and project sponsors while also working directly with the project team and IT development teams

Environment: UML, MS Project, MS Visio, Rational Requisite Pro, MS Office, SQL