SUMMARY

• Microsoft Certified Business Intelligence Developer with 8+ years of IT experience in development, analysis, design, testing, presentation and implementation experience using SQL Server 2012/2008R2/2008/2005,Oracle 11g/10g/9i and SQL Server Data tools.
• Very good hands - on experience in development and implementation of Data Warehouse applications.
• Involved in all the stages of Software Development Life Cycle mainly in Database design, data access and development using MS SQL Server 2012/2008R2/2008,Oracle 11g/10g and Web Applications development.
• Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Data tools or SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a DataWarehousing and Data Migrations.
• Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in creating ETL mappings in Informatica to load data from different sources to different target databases.
• Hands on experience in COGNOS 10.x/8.x Suite (Framework Manger, COGNOS Connection, Report Studio, Query Studio, Business Insight, Advanced Business Insight, Analysis Studio and Event Studio) with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Development Projects in SQL Server and Microsoft.Net.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environment.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0. teradata.

Languages: C#.Net, VB.Net, XML, ASP.NET, T-SQL.

Scripting Languages: HTML, XML, Java Scripting, VB Scripting

ETL & Reporting: SSRS 2005/2008, SSIS 2005/2008

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2Visualization Tools Tableau 8.1/8.0/7/0

Other Tools: MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, CT

SQL BI developer(SSAS/T-SQL)

Responsibilities:

• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Also worked on Cognos Framework manager for reporting.
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Used 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.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes.
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts.
• Hide and Show the objects by using conditional blocks.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, Tera Data SQL Developer, Cognos 8.x/10.x.

Confidential, NJ

SQL Server/BI Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move)
• Perform ETL processes using SSIS tool for SQL Server.
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on Table Partitioning to load current and historical data.
• Worked with Business users to understand the Business Logics as per the need.
• Worked with Financial data to calculate Comp.
• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS)
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Responsible for maintaining and supporting production databases.
• Created standard report subscriptions.
• Created report snapshots and cache for better performance.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, VB.NET Query Analyzer,Tera Data Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, Raleigh NC

SQL BI DEVELOPER

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Configure the SSIS Package for run time Parameters and Configuration file.
• Created store procedures to calculate net return and Gross return of the Funds.
• Performed T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Creating Stored Procedures for SSIS and for Reporting in SSRS.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Maintained scheduling of subscription reports with the subscription report wizard.
• Handling the errors during data moving and Sequencing the task as per requirements.
• De-normalizing database using Stored Procedures for a single row feed to legacy system.
• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front-end application.

Environment: SQL Server 2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, MS-Excel, MS Access 2000, SQL profiler, SQL Server Agent.

Confidential - Alpharetta, GA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Involved with SSIS for sending and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Created database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Migration of DTS to SQL Server Integration Service (SSIS) and Designing/ Implementing Backup policies for databases.
• Created various DDL/DML triggers in SQL Server 2005/2008.
• Creating, maintaining the users, roles and granting privileges and Rebuilding indexes on various tables.
• Wrote SQL stored procedures to implement business logic and Optimized the performance of queries with modifications in T-SQL queries.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Database testing, maintaining the data and writing the procedures.
• Fine tuning the Database Settings as well as the Server Settings.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: SQL Server2005/2008Enterprise, MDX,WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, InfoPath, Access, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, C#, ASP.Net 3.5, VB.Net.

Confidential

SQL BI Developer

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Implemented Event Handlers and Error Handling in SSIS packages.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Weekly Update the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.
• Created a report model on SSAS cubes.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Created Logical/physical Data Model in Erwin and have worked on loading the tables in the Data Warehouse
• Worked extensively with the Erwin Model Mart for version control.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Used SSRS 2008 to create customized reports and ad-hoc reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution

Environment: SQL Server 2005, Erwin Data Modeler, Oracle Golden Gate (OGG), Rational Performance Tester (RPT), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Confidential

SQL BI Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.