SUMMARY:

• Overall 10+ years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Experience in SQL Server as Database Administrator
• Experience in automating day - to-day activities by using Windows Powershell.
• Administration of Database systems using MSSQL 2005/2008/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).
• Experienced in automating, configuring and deploying instances on AWS, Azure and Rackspace cloud environments and in Data centers.
• Worked on ETL Process creation and SSIS package Creation.
• Ability to create scripts using Azure Powershell during for automation and build process
• Excellent in writing customized Python scripts for automation, data parsing, database operations, data extraction, text manipulation, files parsing and reports generation.
• Configuring PostGreSql Streaming Replication and Pgpool for load balancing.
• Experience in upgrading and migrating various versions of PostGreSql database on different platforms.
• Responsible for all backup, recovery, and upgrading of all the PostGreSql databases.
• Experienced in Automation using Python, specifically automating unit/manual test cases.
• Deployed SSIS packages from various Dev environments to QA and Prod.
• Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and scheduling SQL Server Integration Services (SSIS) packages.
• Experienced in developing Web-based Applications using Python, CSS, HTML, JavaScript and jQuery.
• Experience with Design, code, debug operations, reporting and web applications utilizing Python.
• Migration of Data from Reports generated by various vendors into PostGreSql Databases using PostGreSql Export/Import Procedures.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Experience in writing Complex Shell Scripts that automate the Import of Reports to PostGreSql and MySQL Databases.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Hands on experience working in WAMP (Windows, Apache, MYSQL, and Python /PHP) and LAMP (Linux, Apache, MySQL, and Python /PHP) Architecture.
• Experience in working with Python ORM Libraries including Django ORM
• Experience in AWS cloud platform features which include EC2, EBS, IAM, ELB, S3 and RDS.
• Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV's and Efficient coding standards.
• Detailed depth knowledge in Oracle Architecture, Greenplum Architecture, Data dictionaries and DBMS Packages.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk.
• Viewing Greenplum table DDL.
• Append-optimized tables, including compressed append-optimized tables.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Automated Greenplum DB, Command Center and PostgreSQL patching.
• Configured Greenplum DB and command center authentication thru LDAP.
• Experienced in performed partitioning of cubes as well as Cube optimization in order to increase the performance of cubes in SSAS.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2005/2008/2012/2014 ) Packages (Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Ability to migrate the code from one database to the other such as Oracle to GreenPlum.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 across various environments.
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), Top N, Summary, OLAP.
• Excellent Communication and Verbal skills.

TECHNICAL SKILLS:

Operating Systems: Windows Vista/ XP/ 2003/ 2000/ NT 4.0/ 9x, MS-DOS

Programming Languages: T- SQL, PL/ SQL, MDX, C, VB Script, C# .NET, VB .NET

Web Technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0)

Databases: Microsoft SQL Server 2012/2008, MS-Access 97/2000/2003 Oracle 9i/10g

Tools: Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual SourceSafe 6.0, Visual Studio .Net, Microsoft

Management: Console, DTS, SSIS, Business Intelligence Development

Studio: (BIDS), Crystal Reports 9.0, ETL

Database: Design Tools MS Visio, Erwin

Configuration: Clear Case, Clear Quest, Visual Source Safe

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS)

Application Packages: MS Office, Ms Outlook (Microsoft Office Suite)

Portal SharePoint Portal: Server 2003, Windows SharePoint Services

PROFESSIONAL EXPERIENCE:

SQL/MSBI Developer

Confidential - Washington, DC

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Developed, monitored and deployed many SSIS packages
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to provide optimal performance.
• Worked on server Migration of databases, Permissions, Logins, SQL jobs, SSIS Packages, from one server to another server and preparing the corresponding document for other environments.
• Created Tabular reports, Matrix reports, List reports and Sub reports using SSRS.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Used complex expressions to Calculate, Group, Filter, parameterized and Format the contents of the report according to the requirement.
• Used Conditional Formatting to change the behavior of the report depending on the requirement.
• Developed various Custom Code functions using VB Script.
• Deployed the SSRS Reports to the report server and maintained them.
• Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS).
• Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.
• Migrated of classis ASP applications to ASP.Net and C#, MS Access to SQL Server. Environment: SQL Server 2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Microsoft Visual studio 2008, Oracle 10g, Crystal Reports, PL/SQL, T-SQL, XML, Microsoft Visual Source Safe, TFS (Team Foundation Server), Subversion, Pivotal Tracker, MS Access 2003 & Windows Server 2003, VB Script.

SQL Developer

Confidential - Westborough, MA

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB's into SQL Server 2008 R2 staging DB's using SSIS Import &Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Extensive experience in Python web frame works like Django, Pyramid and Flask in implementing MVC architecture.
• Experience object oriented programming (OOP) concepts using Python, Django and Linux.
• Worked on Health Data Conversions for NFL (National Football Leagues) and SeaWorld. Generating on demand reports using eBO reporting using SSRS and adhoc reporting using report builder feature in SSRS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS, MySQL and vb.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions. Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS. Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages to the conversion server and create and schedule SQLServer Agent jobs to automate the run of SSIS packages on a weekly basis. Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes in corporation, logins & permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client.
• Worked with Managers to prepare requirements gathering documents and quality documents. Environment: SSIS 2008/2012,BIDS,SQL Server 2008R2, T-SQL, Visual Basic .Net, Vb6, XML, eManager, eBO reporting, Microsoft Project, SVN, Core Java, Microsoft Access, SSRS, Microsoft Excel, QAS.

SQL Developer/ETL Developer

Confidential - New York, NY

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• Applied knowledge of Normalization and De-Normalization techniques.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQLqueries.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports based on the requirements using SSRS 2008. Environment: MSSQL Server 2008, SSIS, SSRS, BIDS, Visual studio 2008, MS Visio 2007 and XML.