SUMMARY

• Around 8+ years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications.
• Expertise in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications using MS SQL Server 2012/2008/2005/2000 , SQL Server Integration, Reporting & Analysis Services.
• Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Involved in creating numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
• Created Dashboards using Custom Visuals in Power BI.
• Experience in building tabular cubes using Power BI and implementing DAX expressions with in Power Pivot.
• Involved in designing T-SQL programming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user-defined functions.
• Exported stored procedures into a version control system (Perl, SQL Server 2005, T-SQL, PostgreSQL 9.1, plpgsql, Subversion).
• Strong debugging skills and the ability to solve complex problems.
• Business requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Experience in working with various versions of Informatica Power center 9.0, 8.6/8.5/8.1/7.1/6.2 - Client and Server tools.
• Develop data extracts from the data warehouse environment using ODI.
• Extensive experience in writing Stored Procedures, tables, user defined functions, views, indexes, and relational database models and data integrity.
• Developed and maintained mapping logic to Hadoop data sets from a variety of source systems for data integration and creation of consumption model.
• Built the data cubes by implementing SQL Server OLAP services in SSAS.
• Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.
• Managed report by using SSRS tools such as report management, report delivery and report security.
• Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
• Exposure to all phases of Software Development Life Cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Experience in ProgrammingAMO OLAPadvanced objects like KPI’s and Perspectives.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression (MDX).
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Expert knowledge in using data modeling tools likeERWIN and ER diagrams, Normalization Techniques for designing database with Relational technology.

TECHNICAL SKILLS

BI/ETL Tools: SSIS (SQL server integration services), Informatica Power center 9.0, 8.6/8.5/8.1/7.1/6.2 , Oracle Data Integrator (ODI) DTS & Data stage

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/ MS Access, DB2 MS excel 2010, MS Share point.

Operating Systems: Windows 8/7/XP/2003

Modeling Tools: MS-Visio, Erwin

Reporting Tools: SQL Server Reporting Services

Management tool: T-SQL, SQL, PL/SQL, PL/PGSQL C, JAVA, VB, MS ACCESS

Office Tools: Confidential Office /

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr. SQL/Power BI Developer

Responsibilities:

• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Worked on different tabular models such related to devices such as Xbox, Surface and other Confidential devices.
• Used 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.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Exposure in designing, building the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Analyzed and Created SSAS cube and set up role based security in the cube.
• Optimized ETL processes to reduce data load times.
• Resolved daily data warehouse automation issues.
• Ensured data integrity, restorability and appropriately handled data loading errors.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports.
• Created Pivots for the excel reports and used Power View to show the data as per requirement.
• Generated data model using Power Pivot.
• Linked Power BI reports to SharePoint and maintained the reports.
• Automated the Reports using various SSIS packages and jobs.
• Created complex programs in T-SQL and wrote Stored Procedures, Triggers and Queries with best execution plan.
• Created and monitored various SQL agent jobs and sent notifications via email.
• Supported reports Power BI and Visual Basics applications, which are used to generate data in a specific format
• Tested the data accuracy using various data validation techniques.
• Solved business problems by creating different audit reports.
• Worked upon ad-hoc reports and delivered on time.
• Changed the logic behind the reports to filter out the required data as per business requirements.
• Documented all the new data related information and the various methods used to build these reports.
• Fixed DAX expressions to validate the count related to the report.
• Suggested alternative solutions on tasks such as bringing together a number of different data feeds and build a view of customers using data from all the sources.
• Building SSRS reports that can be exposed to / emails to FT stakeholders.
• Built a Power BI framework for customer and FT reporting at all levels of the org.
• Created and edited monthly business reports (MBR).

Environment: Confidential SQL Server 2012/2014, DAX, Visual Studio 2012/2014, Transact-SQL, SQL Server Integration services(SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS Excel, TFS, MDX, Power BI Framework, Power view, Power Pivot, MS Excel

Confidential, Indianapolis, IN

Sr. SQL Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Maintenance of existing Visual Basics and C sharp applications, which are used to generate data in a specific format.
• Supervise .NET applications, dashboards and reports via SQL database.
• Integrated legacy systems across SQL Server and Oracle platforms using integration tools SSIS, Alteryx.
• Created SSIS Packages with time scheduling and various transformations to achieve specific formatted flat files such as pipe delimited, CSV, tab delimited.
• Developed mappings to extract data fromSQL Server, Oracle, Teradata, Flat filesand load into Data Mart using InformaticaPower Center.
• Used Informatica Designer in Informatica 9.0 to create complex mappings using different transformationslike Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformationsto pipeline data to Data Mart.
• UsedInformatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows accessed information using DB2 and AS400.
• Application remains responsive to the user via multi-threading to handle long-running calls to Active Directory, SSIS packages and SQL Server 2005 stored procedures.
• Created internal migration tools and user interfaces.
• Worked on 5 life cycles for development on ODI and 2 life-cycles on OBIEE.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Migrated and normalized SQL Server 2000, PostgreSQL 8.1, and MySQL 4.0 databases.Exported stored procedures into a version control system (Perl, SQL Server 2005, T-SQL,PostgreSQL 9.1, PL/PGSQL,and Subversion).
• Implement and maintain integration processes that adhere to Roche CSV, Application Specific Development Guidelines, Naming Conventions, Roche Best Practices and Security Policies.
• Responsible for supporting/developing/deploying integrated solutions aimed at modernizing, consolidating and coordinating the independently designed applications within and across enterprises.
• Determine how existing applications, legacy systems, databases, Cloud services, Service providers, Web interfaces and/or hardware logic, work together to meet new and emerging enterprise requirements. Follow methods to efficiently reuse existing components.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users.
• Testing use cases using JUnit.
• Experience in creating documentation like Source - Target Mapping (STM) documents, Run books, functional requirements and technical design documents.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Request Broker Architecture, Enterprise Service Bus, Service Oriented Architect, enterprise -wide content and data distribution using common databases, communication protocols and data standards implemented with Extensible Markup Language (XML), industry standard formats, middleware applications and message queuing approaches.
• Specialized knowledge of integration processes and systems. Supports, manages, organizes, and Roche standards (including, but not limited to, Naming Conventions, Security Policies, Development Standards, Project Methodology) are enforced.

Environment: Confidential SQL Server 2008/2012, Visual Studio 2008/2012, Transact-SQL, SQL Server Integration services(SSIS), Informatica Power center 9.0, 8.6/8.5/8.1/7.1/6.2 , JUnit, .NET Framework, Alteryx, VBScript, Erwin, Confidential Visio 2010, MS Excel, Oracle 10g Enterprise Edition, Oracle Data Integrator (ODI), OBIEE.

Sr. SQL Developer

Confidential, Philadelphia, PA

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system modular, secured and extensible.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in Oracle Data Integrator (ODI).
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Done Performance tuning using TOAD.
• Worked on Excel Power Pivot for providing ad-hoc reporting for the clients.
• Deployed and generated reports on the server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Created various Dash Boards using Performance Point Serverenhancing performance using optimization techniques-normalization, indexing and transaction isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Linked Servers to connect OLE DB data sources and providers
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe so as to make the sensitive data secure.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2000 databases to SQL Server 2008.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan
• Perform Capacity monitoring, short, and long-term Capacity planning in collaboration with development resources and System Administrators.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2012 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Oracle Data Integrator (ODI), Business Objects(BO), visual studio 2008, Performance Point Server, Confidential Office Share Point Server, TOAD, OLTP, OLAP, XML.

SQL Developer

Confidential, Jacksonville, FL

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Involved in Designing Logical and Physical Data Models.
• Written Stored Procedures, complex queries, Views and Functions, Triggers in SQL Server 2008R2 environment.
• Experience in designing, development and implementation of Hadoop related big data solutions including map reduce jobs, pre-processing and loading of varied data sets, enabling use cases related to data visualization & analytics.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created SSIS packages to populate data from various data sources Flat Files, Excel Files, OLE DB to SQL Server.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Evaluating data modeling, database administration, and database backup, recovery tools, and make recommendations.
• Used Policy Based Administration feature (SQLServer 2008)
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked on SSIS Packages to pull the data from different Sources and load to Data mart.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Bulk-copy the data from Text files to SQL Server.
• Experience on Database scripting, PowerShell, UNIX command and Shell Scripting.
• Involved in fine Tuning and Performance and Query optimization as required by the application.
• Conducted data import and export operations.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS 2008), Hadoop, SQL Server Integration Services (SSIS), Data Stage, Business Intelligence Development Studio (BIDS), OLAP.

SQL Developer

Confidential, Providence, RI

Responsibilities:

• Gathered user requirements to develop the business logic, analyzed, and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of pre-staging data from AS400 systems to subsequent target layers in SQL Server 2008R2.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, Triggers and queries for automating various interface tasks using T-SQL.
• Defined testing strategies, designed Test Plans to test each system interface output, and validated output data from each Interface based on respective Test Plans.
• Ensured the quality of the output for each system interface by conducting meetings with the respective vendors to review the output and obtain continuous feedback.
• Identified and defined Key Performance Indicators (KPIs) for vendor reporting.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Modified the existing SSIS packages, Script Component Task to meet the changes specified by the users and adding column to the newly design table and to the existing table.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, sorting the data, defining data sources and subtotals for the reports using SSRS 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created Tabular reports, Cross Tabs, Drilldown, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Environment: SQL Server 2008, SSIS, SSAS, SSMS, XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3., Net 4.0/4.5, TFS 2005/2008/2010

SQL DEVELOPER

Confidential, Philadelphia, PA

Responsibilities:

• Plan, design, and implement application database code objects such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data files for counterparties.
• Involved in creating and modifying PLSQL and SQL*Loader scripts for data extractions, conversions(ETL) and Automating data loading, extraction, report generation using UNIX shell scripting.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Migrated the main database from MySQL to PostgreSQL.Modeled, developed, and administrated the database.Monitored setup for PostgreSQL, MySQL servers.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Trained and mentored EBI team, users and assisted and coached them in material, processes and delivery of training, training standards and best practices.
• Interacted with report owners to establish/clarify their requirements and developed report specifications.
• Performed development activities from gathering requirements and designing solutions, through developing code/ reports, to testing and release / deployment.
• Involved in developing test plans to conduct the Unit and Integration testing for the batch framework and Autosys rescheduling.
• Worked on Technologies like Oracle Data Integrator 10g/11g and OBIEE 10g.
• Organized and supervised formal reviews of development documentation (requirements and design documents, system test plans)
• Involved in scheduling the batch jobs using Autosys.

Environment: Confidential, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, Oracle Data Integrator (ODI), UNIX shell scripting, MS Access 2000, Autosys.

SQLDEVELOPER

Confidential

Responsibilities:

• Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project.
• Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering followed by (Agile Scrum) approach.
• Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs.
• Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.
• Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.
• Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements' values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values.
• Designed and optimized the design of a database to include recent Postgre (PGSQL) features.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.

Environment: MS Visio, MS Office Suite, HTML, XML, Test Director, VB, Client Server, UML, Waterfall, Windows XP, Test Director, Oracle Data Integrator (ODI), MS Project, MS Access, PL/SQL, Oracle, TOAD.

BUSINESS ANALYST

Confidential

Responsibilities:

• Using a wide range of techniques to capture business requirements.
• Identifying an organizations strengths and weaknesses.
• Working with business owners to develop solutions.
• Assisting in the preparation of business proposals.
• Documenting, testing and implementing software updates.
• Identifying client business requirements.
• Defining project scope and objectives.
• Preparing and analyzing financial performance information.
• Allocating junior staff to tasks and then tracking the progress of their work.
• Making sure that all tests are conducted and documented according the standards agreed upon.
• Proficient in Confidential Office programs.
• Identifying and managing any anticipated resistance or risks.
• Involved in the definition of roles and responsibilities.
• Carrying out business improvement reviews.
• Meeting with project teams to review deliverables and deadlines.
• Producing test plans and scenarios on behalf of the business.

Environment: Confidential Office, Oracle 9i, Rational Clear Case, XML, MS Visio and Manual Testing.