Professional Summary:
Over 7 years of experience in data modeling, data design, database programming of SQL Server 7/2000/2005/2008 for OLTP/OLAP/ETL environments. Extensively worked on Datamodelling, Normalization and De-Normalization techniques for both OLTP and OLAP. Highly experienced with DTS/SQL server integration services (SSIS 2005) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers. Proficient in creating highly analytical & detailed reports from ERP system for various departments like sales, purchasing, inventory, financial, customer service, marketing, datawarehouse, and human resource by using Sql Server Reporting Service, Sql Server Analysis Service (OLAP). OLTP Experience
Experienced in writing SQL, T-SQL, stored procedures , triggers, and functions in MS SQL Server 2005 Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults. Implemented SQL Server Indexing, Index tuning using Index Tuning Wizard and Tuning Advisor Excellent knowledge in performance tuning and query optimization Using SQL Profiler, Execution Plan, Performance Monitor.
OLAP Experience(SSIS,SSRS,SSAS)
Migrated and Upgraded DTS Packages to SSIS Packages across all environments. Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications. Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS). Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages. Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement Hands-on-experience on Reporting Architecture components and various tools of SQL Server Reporting Services(2000/2005) Solid design and development experience in Developing various kind of reports (cascading parameters, pick lists, drill down and drill through) Created Adhoc reports and data driven subscription reports by using Report Builder in SSRS Expertise in Troubleshooting, Installation, Configuration and Deployment of Reporting services using SSRS (2000/2005). Expertise skills in creating OLAP cubes ,calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions . Solid Knowledge in Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles. Proficient in designing 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 Analysis Services. An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability. Work experience is combined with professionalism, determination and strong work ethics. TECHNICAL SKILLS
Operating Systems : Windows 2003/2000 Advanced Server, NT & Windows 9x, LinuxOS, UNIX.
Tools : SSIS, SSAS, SSRS, VSS 2005/6.0, TFS, Erwin 4.0, Spotlight,DBArstisan.
RDBMS : MS SQL Server 2000/2005/2008, MS Access, Oracle 8i & 9i, Sybase.
Languages : T-SQL, MDX, PL/SQL, C, Visual Basic 6.0, VB Script, VB .NET, ASP .NET
Web Technologies : XML, HTML, XSL, JavaScript, IIS.
Database Utilities : Enterprise Manager, Query Analyzer, SSMS, SQLProfiler, DTS/SSIS,
Business Intelligence Development Studio (BIDS), Perfmon.
PROFESSIONAL EXPERIENCE:
Confidential,MO July’ 12 - Present
Sr BI/SQL Developer
Responsibilities:
Worked with the business, stakeholders and the solution architects to define the User Stories for the business requirements. Attended three day Agile Bootcamp – Client Site from ASPE SDLC Training. Involved in Iteration planning for user stories, breaking them into tasks and pointing the stories. Attended daily stand-ups for status updates. Created Stored Procedures(merge, interface), Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results. Involved in performance tuning. Worked on code reviews through code collaborator. Created minimal and marginal unit tests for stored procedures. Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables. Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS). Designed the Structure of Staging Database and Staging Tables used in the ETL Process to dump data into a common Staging. Used the SSIS Configuration files to make the packages connections, variable values etc configurable and maintained the same on Test and Production Environments. Scheduled SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files to run on a regular basis. Performed Database Administration activities like Back up, Restore, Security etc. Created rollout and rollback scripts to deploy changes to production. Involved in production deployment and post-production support. Creating and managing users, roles and assigning necessary permissions. Worked on Team Foundation Server to branch down, merge down/merge up, checkin /checkout etc., Environment: SQL Server 2000, 2005, 2008/R2 SSRS/SSIS 2000/2005/2008, Agile.
Confidential,VA May’11 – June’12
Sr BI/SQL Developer
Responsibilities:
Involved in the gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design Documents and Approach Documents and Implementation of BI Analytics needs. Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results. Designed and Developed 150+ Reports for Membership Module, these include Drill down Reports, Drill through Reports, Sub Reports, Charts, Lists, Images, Tablix etc. Analyzed the Legacy Crystal Reports using Business Objects viewer and converted then to the SSRS Reports in MSCRM 4.0. Used CRM Filtered Views, Stored Procedures to generate the SSRS Reports. Used Vb.net script in reports for custom formatting to get the reports in desired format which is not available in SSRS. Created Reports using SSRS from the Copy Databases for Monthly Membership Stats, used Linked Reports for this Purpose. Implemented Report Subscriptions and scheduled them to run on specific day and time and send to the top-level management using email subscriptions. Created different Parameterized Reports (SSRS 2005/2008) such as Cascading Parameters, Multivalue Parameters, Queried and Non Queried Parameters (Date Time) etc. in various reports to minimize the report execution time and to limit the number of records required. Monitored the Report Server and SQL Server and performed administration tasks assigning roles, permissions, privileges in Report manager. Published Reports on CRM or uploaded the reports on SQL Report Manager. Designed mailing Subscription reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server. Created shared data sources that can be used across different reports extracting data from source. Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables. Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS). Designed the Structure of Staging Database and Staging Tables used in the ETL Process to dump data into a common Staging. Extensively used Data Flow Task, Look up, Script Component etc in the SSIS Packages. Worked on Debugging and execution of these packages by creating the checkpoints and breakpoints wherever necessary based on the requirement. Implemented Custom Error Handling (Record Level) by using the Script Component to generate custom error messages and redirected the error rows to a staging error table. Used the SSIS Configuration files to make the packages connections, variable values etc configurable and maintained the same on Test and Production Environments. Scheduled SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files to run on a regular basis. Performed Database Administration activities like Back up, Restore, Security etc. Designing and building high availability plans like replications and Transactional log shipping. Environment: SQL Server 2000, 2005, 2008 SSRS/SSIS 2000/2005/2008, XML, MS Project, MS Access 2000 & Windows 2K/2003 platform, Share Point, Crystal reports.
Confidential,IA March’10 –May’ 11
Sr BI/SQL Developer
Responsibilities:
Involved in the gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design Documents and Approach Documents and Implementation of BI Analytics needs. Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results. Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, matrix, charts ,sub-reports, navigation reports (Hyperlink) etc. Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required. Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format. Developed the packages with monitoring features and logging capturing the audit information of the packages and their execution results for support and troubleshooting Involved in Deployment of SSIS Packages across various Production, QA and Pre-prod environments. Scheduled SSIS Package Jobs and monitored the jobs using SQL Server Agent. Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 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. Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS. Experience in Error Handling using TRY and CATCH blocks, performance tuning using counters in SSIS. Defined OLAP cubes based on fact tables and dimension tables to suit a range of report/analysis requirements with SQL Server 2005 Analysis Services (SSAS). Connected the database using ADO.Net connections. Environment: SQL Server 2000, 2005, SSRS/SSIS 2000/2005, XML, MS Project, MS Access 2000 & Windows 2K/2003 platform, Share Point, Crystal reports.
Confidential,IN Mar ’08 – Feb ‘10
Sr BI/SQL Developer
Responsibilities:
As a member of BI/Database team, Involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs. Involved in supporting more than 70 Users for various Reporting and Analytics requirements across multiple Business Units and departments. Designed and developed more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads,SSAS Cubes and various heterogeneous data sources. Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions. Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources. Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS). Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various 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 calculated measures that fits business logic. Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS). Designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service. Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server. Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes. Created Analytical reports by using ProClarity tool. Complete administration of Report Server 2005/2008 which involved creating logins, maintaining item level security, managing roles and granting permissions. Involved in Database Administration activities like Back up, Security. Environment: SQL Server 2000, 2005,2008,SSIS,SSRS,SSAS, XML, MS Project, MS Access 2000 & Windows 2K platform, Share Point ,Crystal reports, Oracle 9i, C#,.Net
Confidential,IL May ’06 – Feb ‘08
SSRS/SSIS/SQL Developer
Responsibilities:
Actively participated in supporting and enhancing logical design of the system to incorporate changing business and user requirements. Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles. Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones. Involved in writing lots of reports incorporating business logic and user requirement. Designed ad-hoc reports, grouping and sorting using SSRS and Crystal Reporting 9.0. Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources. Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs). Created large enterprise reports for various Business functionalities assigning report parameters. Written SSIS packages in 2005 and did conversion DTS packages from 2000 to 2005 Good Hand on Resolving complex issues and Error Handling in SSIS. Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc and vice versa. Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks. Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints Developing OLAP cubes using SSAS 2005 and calculate the metrics that were revealed in the functional analysis. 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 of star schema and snowflake schema in Analysis Services (SSAS) Environment: SQLServer 2000/2005,SSRS 2000/2005,SSIS/DTS, Visual SourceSafe, Enterprise Manager, Query Analyzer, SQL Profiler ,Active Directory and Windows XP platform, DOT NET 2.0, DB2 (Main-Frame), VB Script, MS Visio.
Confidential,IL Nov’ 05 – April ‘06
SSRS/SSIS/SQL Developer
Responsibilities:
Involved in Design, development, Implementation and support of ETL Process involving various data sources across different countries. Performed the Data extraction from various data sources involving Oracle, SQL Server, Flat Files, Legacy databases and various other RDBMS Sources. Scheduled daily loads (FULL & INCREMENTAL) into Staging and ODS areas, Involved in trouble shooting process issues and errors. Used VB.Net, VB Scripts For Loading data using SSIS Packages. Designed the SSIS packages using various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Wrote Custom VBScript to handle the Row Level Error Handling in the SSIS Packages. Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements. Extensively performed the Design, Development, Processing and deployment of Cubes from the different fact and dimension tables based on the business requirement using SSAS Gathered the requirements directly from the Users and Working on the reports to ensure that report is acceptable. Used ProClarity, PPS and SSRS to Design and Develop reports from these OLAP cubes. Performed the development, deployment, maintenance and support of different Inventory Control and Finance reports. Experienced in Writing Enterprise Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters etc. Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS) Deployed and uploaded the SSRS reports to SharePoint Server and Report Manager in various phases of SDLC Process for the end users to look at them. On a Regular basis Created Store Procedures, Indexes, User defined Functions, Constraints etc on a daily basis for the reporting and query optimization. Involved in Performance Tuning of the Store Procedures when needed, creating indexes, Hash Join, etc so that the report execution time is minimized and ensured that the Optimized Execution Plan is used. Experienced in Agile and Scrum Methodologies and Participated in the knowledge transfer process and share the knowledge with the client team. Used complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner, Merge Join etc Developed Reusable Mapplets and Transformations for reusable business calculations. Developed workflows and tasks using Informatica Power Center Work flow Manager. Environment:
SQL Server 2000/2005 , SSRS 2000/2005, SSIS, Informatica 8.5.1,Visual SourceSafe, OLAP, ProClarity, Performance Point server Enterprise Manager, Query Analyzer, SQL Profiler ,Active Directory and Windows XP platform, VB. NET 2.0, DB2 (Main-Frame), Erwin 5.1,Database Diagrams, MS Visio, Control-M.
Confidential,Hyderabad, India Jan\'05-Oct’05
Role: Trainee SQL Server Developer/DBA
Responsibilities:
Designed, implemented and administrated SQL Server 2000 databases. Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables. Create and Modify Stored Procedures, Triggers, Views according to the business. Developed various reports to validate the data between source and the target systems. Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server. Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries. Experience in Database Backup, Recovery and Disaster Recovery procedures. Environment: SQL Server 2000 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2000, Windows Active Directory, MS Access, MS Excel
Educational Qualifications:
Bachelor of Technology .
Privacy Policy
