EXECUTIVE SUMMARY:

• Skilled Information Technology Professional / Consultant with 10 years of software marketing and 15 years of Core Microsoft Development experience in Business Intelligence stack (SSIS/SSAS/SSRS).
• Well familiar with unidata database platform and common database commands.
• Comfortable writing sql queries to query unidata database to erite report for the reporting
• Skills in Large DBA, MS SQL, MSDN, SSIS, SSAS, SSRS Configuration, Implementation and Migration. Server upgrades. Disaster Recovery Plans: Replication, Log shipping, Mirroring, SRDF. Database Growth Monitoring
• Specific experience with correct logical implementation, and timely resolving DTAP / Development, Testing, Acceptance and Production issues.
• Knowledge in scalable architecture for personalized business of building data warehouse and OLAP cube design
• Have experience in DTAP for best practices in extremely large Databases.
• Specifically implemented higher efficiency and standardization frameworks for SSIS configuration in design
• Extremely knowledgeable in new features of MS SQL 2012/2014 to provide the best results for clients. Worked with most tools on SQL server for monitoring, database design, and troubleshooting specifically on Spotlight, Fog Light, Lite Speed, Red Gate Tool Belt (schema compare, data generator), Microsoft Best Practice Analyzer, Erwin database artisan
• I have worked for some of the best fortune 500 companies in the USA in security Audits, Compliance, TFS change and release management, and automated deployments.
• Special talents include highly creative, problem solver, result oriented individual. Can collaborate with both small and large teams and can work independently with minimum supervision.
• Currently upgrading my skill set in Hadoop and Big data
• Installed rhadoop on hdinsight, installed extensions or libraries for rhadoop, partitioned tables using table partitions in rhadoop installed spark server on windows/virtual windows machine executed spark routines from github

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential, Camp Hill, PA

Responsibilities:

• Worked for Delaware Social Services Modernization Project
• Data modelling for OLAP cubes using Erwin.
• Guiding development Teams for development work on the Delaware modernization project on SSIS work
• Using Master child package configurations
• Created Cubes on SSAS 2012
• Worked on SSIS on sq 2008 package configurations/Table package configurations/Package Environment variables.
• Used all types of transformations in SSIS /used different types of tasks (data Flow Task / merge/split)
• Used different types of containers: - Data flow/Loop Containers/for each loop /Sequence
• Optimized SSIS Packages for large data Loads ( set up commit batch size made logging simple)( about 10 to 12 things to take care of to make sure SSIS packages work well)
• Implemented sliding partitions taking data from ibm db2 data to sql server.
• Created error handling routines(Logging to tables/File)
• Migration of project using manifest files
• Helping entire SSIS teams with performance issues setting up SSIS data validation routines. Using SSRS
• Created parameterized tabular report using stored procedures as data source
• Created Drill down and tabular reports
• Index recommendations for data loads.
• Developing Suitable solutions for tlyse Applicant Eligibility for the physical file layouts for tempdb, VLDB solutions and so on.
• Worked with SSRS groups populating data
• Worked on SSRS reports creating different types of reports.(simple/tabular/drill down)
• Worked on tableau reporting tools
• Created B I Dashboards for CEO Reporting
• Created Eligibility cubes to applicant Eligibility for Benefits.

Business Intelligence Developer

Confidential, Horsham, PA

Responsibilities:

• Developing Warehouse solutions for the Camaro data warehouse, Developed the ODS, the Data warehouse and the ETL processes, data validation process and the processes for sox compliance.
• Working on optimizing data loads for the SSIS packages
• Developing sliding partitions for Large Database Data Loads
• Optimizing VLDB loads
• Incorporating Appropriate data feed mechanisms for data loads
• SRDF configurations
• Migrating SSIS packages from development to production
• Database administration tasks like designing data migration process, database security server installs Building Servers etc.

Database Developer

Confidential, NY

Responsibilities:

• Worked on ASBS project for Verizon, Responsible for developing the solution from scratch.
• Schema design, ETL design, database design for hub and spoke Develop azure for the database.
• Worked with hierarchal data types and xml databases in data design.
• Advanced Smart Building Solutions was an initiative to capture the reduction in electric consumption by using smart building solutions for Verizon .It used Latest energy efficient processes and smart solutions to maintain temperatures within a building and shut off electricity based on occupancy.
• Developed an ETL framework including detailed design for loading data from the transactional systems to the ODS and from ODS to warehouse.
• Configured both table based and xml based configuration for ETL packages.
• Set up package logging and error logging for ETL LOADS.
• One of the largest implementation of OLAP in the north eastern region.
• Worked on Building an ETL framework on SSIS and making ETL packages for data loads.
• Worked on Building the SSIS packages to load data from flat files to the data warehouse using SSIS this was on SQL 2008 R2.

Business Intelligence Developer

Confidential, Philadelphia, PA

Responsibilities:

• Created the Database schema for the consumer Book of records and the policy book of records
• Analyzed the CDI Upload process for the ETL from the Mainframe to the Data mart Using the SSIS packages and came up with recommendations.
• Integration documents for the ETL process from The Flat Files to the Database for the different environments.
• Migration of Existing Mainframe processes to SSIS SQL based processes so as to reduce the costs and improve cycle times by Automation.
• Created the SSIS packages to load the consumer book of records database and the claims books of records.
• Build the data validation systems to monitor source to data loads and make them SOX complaint.
• Set up restart on failure and check pointing for multiple data loads.