Summary

• A Microsoft Certified Professional with 7 years o experience in Database Design, Development and implementation o Data Warehouse BI Solutions , Database Programming, Data Modeling, Testing o SQL Server 2000/2005/2008/2008 R2/2012.
• Extensive hands-on experience in Database development for both OLTP Batch Processing, Online Processing
• OLAP Systems SSRS, SSIS, SSAS .
• Knowledge o complete software development life cycle SDLC including Requirement Analysis, Requirement
• Gathering, Design, Development, Implementation and Testing and Development experience.
• Extensively worked logical physical Data modeling, data architecture design, Normalization and
• De-Normalization techniques for both OLTP and OLAP Star Schema/Snowflake schema
• Work Experience on Cognos 8 BI, Cognos Framework Manager, Report Studio, Query Studio
• Involved in Designing numerous DB Objects like Tables, Constraints Primary Key, Foreign Key, Unique ,
• Indexes, defaults, rules
• Involved in writing Complex Queries, Stored procedures, Batch Scripts, Triggers, Functions, Views
• Using SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins
• Tuning the performance o Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient
• Coding standards.
• Data migrating using ETL tools like DTS, BULK INSERT, BCP between different homogeneous/heterogeneous systems and SQL Server as a part o Data Migration and Data Maintenance.
• Highly experienced in whole cycle o DTS/SQL server integration services SSIS 2000/2005/2008 Packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL Purposes across different servers.
• Expert in designing Enterprise reports using SQL Server Reporting Services SSRS 2000/2005/2008/2008 R2 , use o multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features o reporting service.
• Good knowledge o Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services SSAS
• Expertise in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modelling, Physical Modelling, Dimensional Data Modelling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Expertise skills in creating OLAP cubes ,calculating measures and dimension members in SQL Server Analysis Services SSAS 2005/2008 using multi-dimensional expression MDX , mathematical formulas, and user-defined functions.
• Developed cubes using Partitions, KPI's, and Perspectives, slowly changing dimensions etc. and created various user roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Creating and Managing users, roles and assigning necessary permissions
• Created Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance point server that use different types o web parts and excel services for reports
• Working Knowledge o Power Pivot, InfoPath.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks can take initiative to handle responsibilities independently as well as a proactive member o a team.
• OPERATING SYSTEMS Windows XP/2000/2003/2008/NT 4.0/9x/Vista/7 and MS-DOS, UNIX
• RDBMS MS SQL Server 2000/2005/2008/2008 R2, MS Access 97/2003/2005,
• Oracle 8i/9i/10g
• LANGUAGES T-SQL, PL/SQL, MDX, C, ASP.net, VB.net, C .NET
• WEB TECHNOLOGIES HTML, XML, XSL, JavaScript, IIS 4.0/5.0/6.0
• TOOLS AND PACKAGES SQL Server Management studio, Enterprise Manager, Profiler, SQL
• Server Business Intelligence Development Studio BIDS , DTS, SSIS,
• Crystal Reports9.0, Visual SourceSafe6.0, Team
• Foundation Server, Visual Studio .NET, ETL, ProClarity, Power Pivot, Source
• Gear Vault
• DATABASE DESIGN TOOLS MS Visio, Erwin4.5/4.0
• BI TOOLS SQL Server Reporting Tools SSRS , SQL Server Integration Services
• SSIS , SQL Server Analytical Services SSAS , Business Intelligence
• Development Studio BIDS , Visual Studio, Crystal Reports, Cognos 8,
• Hyperion, Tableau
• APPLICATION PACKAGES Microsoft Performance Point Server 2007, Microsoft Office SharePoint
• Server MOSS 2007, Microsoft Project Server.
• MCTS: Microsoft SQL Server 2005-Implementaion and Maintenance Exam: 70-431
• MCTS: Microsoft SQL Server 2005 Business Intelligence-Implementation and Maintenance Exam: 70-445
• Brain Bench Certification in SQL ANSI , June 2014
• Bachelor o Technology B.Tech in Electronics and Communications Engineering, from Jawaharlal Nehru Technological University, Hyderabad, India

Confidential

Sr SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Supported Enterprise BI Development and support for various Business Divisions at Harte Hanks interfacing Microsoft CRM Applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Used different control flow tasks such as Sequence Container, For Each Loop File Enumerator, ADO Enumerator , For Loop, Execute SQL Task, Execute Process task, Script task and FTP task.
• Implemented different transformations like Look up, Dynamic Lookup through variable, conditional split, derived columns, multicast, union all, sort, merge, pivot transformation.
• Experience with SSIS performance tuning using counters, event handling, re-running o failed SSIS packages using checkpoints and scripting with Active-X and VB.Net in SSIS.
• Scheduled SSIS packages as jobs to run automatically to Process the cube, load data etc.
• Generated multiple Enterprise reports from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features.
• Designed various SSRS reports using different reporting features such as group by, drilldowns, drill through etc.
• Created various parameterized reports multi value, hidden, default etc. for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types o report layout options like charts bars, lines, pie etc. , images, sub-reports, and hyperlinks to make them more attractive and understandable.
• Involved in Administration o SQL server reporting services SSRS .
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Helped the users to test the reports created and optimized the performance o the end reports getting data from SQL server Databases
• Developed OLAP cubes using SSAS 2008 and calculated the metrics that were revealed in the functional analysis.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the Sql Server Analysis services.
• Played a major role in production support o SSAS cube refresh , SSIS jobs.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes Star Schema across all environments.
• Worked on Key performance Indicators KPIs , design o star schema and snowflake schema in Analysis Services SSAS
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML etc.

Tools and Technologies: MS SQL Server 2008/2008 R2, Business Intelligence Development studio SSRS /SSAS/SSIS , Microsoft Share Point Portal Server, C , ASP.NET, VB.NET, MS Excel, Source Gear Vault, Visual Source Safe, Project Server.

Confidential

SQL BI Consultant

Responsibilities:

• Designed ETL packages dealing with different data sources SQL Server, Flat files etc. and loaded the data into target data sources by performing different kinds o transformations using SQL Server Integration Services.
• Developed new mappings using SSIS Look Up/Aggregation Transformations to match the needs o the business case.
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group.
• Created, published, and modified several packages in Framework Manager according to the business needs.
• Developed Standard Templates, which laid a foundation for all reporting needs.
• Analyzed the requirements and specifications to create the Reports, Quarterly Package and Dashboards.
• Developed advanced reports using Report Studio and Ad-hoc reports using Query Studio.
• Created reports, Drill through Reports and Cross Tab reports using Cognos Report Studio.
• Resolved level 3 Support tickets for assigned applications.
• Worked with TFS Team Foundation Server to keep track o all changes made in the project.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Experience in Planning and Monitoring reports in Performance Point Server.

Tools and Technologies: MS SQL Server 2008/2008 R2, Business Intelligence Development studio SSRS /SSAS/SSIS ,Cognos 8 BI, Cognos Framework Manager, Report Studio, Query Studio .

Confidential

BI Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop datamodels physical/logical datamodels based on the given specs and requirements.
• Transferred data from various data sources/businesss systems including MSExcel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Involved in development Deployment o SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Developed Cubes using SQL Analysis Services SSAS and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment o Cubes to the production server.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation o queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked on large data warehouse Analysis services servers and developed reports and KPIs using SSRS, ProClarity
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Generated multiple reports SSRS/Crystal from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Created different Parameterized Reports SSRS 2005/2008 which consist o report Criteria in various reports to make minimize the report execution time and to limit the no o records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted o different parameter types like hidden, internal, default queried and non-queried parameters .
• Worked on all types o report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.

Tools and Technologies: MS SQL Server 2008/2008 R2, Business Intelligence Development studio SSRS /SSAS/SSIS , Microsoft.NET, MS Office Access 2003, VBScript, Erwin, Visual Studio 2008, Power Pivot.

Confidential

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality o various modules
• Worked on developing Tables,Indexes,Views,Creating complex stored procedures,Triggers,Functions
• Designing Enterprise reports using SQL Server Reporting Services SSRS 2005 and Excel pivot tables based on OLAP cubes which make use o multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features o Reporting service.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005/2008.
• Involved in source Data Analysis, Design and Creation o Data Mappings for Extraction o bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Created Data-data packages in SSIS as part o the automating the process for billing method.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services SSIS
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent and using Shell Scripts,VB Script and batch .bat files on a day to day basis
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Developing OLAP cubes by identifying tables fact and dimension , data source and data source views ,attributes and dimension members using SQL Server Analysis Services SSAS
• Developed many MDX queries for creating measures that fits business logic
• Worked on Key performance Indicators KPIs ,design o Star schema and snowflake schema in Analysis Services SSAS
• Published reports on to the Sharepoint and created Webparts in Share-point to show various reports generated from Excel and SSRS in one web part page
• Created forms on share-point to show livedata from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.

Tools and Technologies: Sql Server 2005/2008, SSIS, SSRS, SSAS, XML, MS Project, MS Access 2000 and Windows 2k platform, SharePoint, Crystal reports

Confidential

SQL Developer

Responsibilities:

• Involved in Designing architecture o the warehouse, Logical Physical Data modeling, data Dictionary mappings
• Involved in writing various DB Objects like User defined functions, Views, Instead o triggers, Usage o Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query
• Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by Performing different kinds o transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns, Merge Join, Conditional Split, Data Conversion with Multiple Data Flow tasks
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL
• Table and log files
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids, Debugging and
• Maintenance o ETL packages and ETL optimization using SQL Server best practices
• Configured ,Installed, Administered Reporting Services 2005
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through/Drilldown Reports and Created Large Number o Report Models for users to create their own reports.
• Deployed the solutions on Web Server, Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions
• Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables
• Involved in optimization o Data Models using Kimball Methodology
• Developed OLAP Cubes by using SQL Analysis Services SSAS and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI's, Perspectives and Roles.
• Extensively involved in the SSAS storage methods MOLAP, HOLAP, and ROLAP , partitions, and aggregations, calculation o queries, Data Mining Models, developing reports using MDX and SQL.
• Deployment o SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down
• Reports, report models, KPI's and Dashboard/Scorecard reports.
• Created and modified Dashboard pages in SharePoint server that use Excel Web Access web parts and reporting services web parts and Used Excel Services for reports and we parts
• Involved in creating Metadata models using multiple data sources using Framework Manager
• Created parameter maps, calculations and relationships in Framework Manager.
• Involved in organizing the Framework Manager model into several different business views based on end user requirements
• Worked extensively on applying and maintaining Security for several different users in Report Net developing prompt pages and conditional variables
• Involved in testing and improving report performance.
• Used Team Foundation Server to store, run, view, edit and revert back to different versions o the design and development phases
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Involved in code reviews, change control and auditing procedures

Tools and Technologies: T-SQL, PL/SQL, MS SQL Server, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Business Intelligence Development Studio BIDS , ETL, MS Excel, Team Foundation Server, Windows Server, VBScript, Cognos.